sumif date range

[IME410]

I am trying to do a simple sumif, but the formula always gives me zero.

I need to sum numbers in column F if the dates in column A are within a certain range. I would like this range to come from dates in cells on another worksheet. If I hand type the dates, the numbers populate correctly, but if I select the cell with the dates in my formula if will not calculate and gives zero for the answer. It seems to be from the >,< signs because if I am going for an exact match it will calculate.

In the formula A2 is my low date and A3 is the high date for the range.

=SUMIF('GFRC Schedule'!A3:A136,">A2",'GFRC Schedule'!F3:F218)-SUMIF('GFRC Schedule'!A3:A136,">=A3",'GFRC Schedule'!F3:F218)

 

[pgc01]

Hi IME410

Instead of ">A2" use ">"&A2, the same for ">=A3" -> ">="&A3

HTH
PGC

 

[awalle]

Try taking out of the quotation mark and use concatenate symbol "&".

The formula will change to this:

=SUMIF('GFRC Schedule'!A3:A136,">" & A2,'GFRC Schedule'!F3:F218)-SUMIF('GFRC Schedule'!A3:A136,">=" & A3,'GFRC Schedule'!F3:F218)

This should work.

Hope this can help you.
AWalle.

 

[IME410]

Thanks! Perfect.