SumIf criteria can't be less than a cell reference

[LIZJOHNSTON]

I'm having trouble with the following SUMIF command:

=SUMIF(dollars!$G$3:$G$8863,"<=A6",dollars!F$3:F$8863)

If I hard code a date instead of using A6 as the criteria, the SUMIF
works. For example, if I enter "<=04/01/04", the SUMIF works. But I
don't want to hard code the date in the formula; I'd rather reference a
cell -- which I can do as long as I don't ask for "greater than" or
"less than".

Can you check for "greater than" or "less than" when referencing a cell
value in the criteria of the SUMIF command?

Thanks,
Liz

 

[Frank Kabel]

Hi
try
=SUMIF(dollars!$G$3:$G$8863,"<=" & A6,dollars!F$3:F$8863)