SUMIF and DATES

[BerlinHornet]

I'm using a SUMIF statement where the criteria tests to see if a date is before a fixed date in another cell.

=SUMIF(A4:A24,<D2,B4:B24)

where A are dates entered as MMM-YY format and "D2" is a date in the same format.

SUMIF does not seem to work for dates and I can't find "help" on the issue

[Domenic]

Try...

=SUMIF(A4:A24,"<"&D2,B4:B24)

Hope this helps!

[BerlinHornet]

Your tips make the formula give me an answer - thank you - but it is still incorrect. I simplified the formula to what I've shown below:

=SUMIF(A4:A5,"<="&D4,B4:B5)

testing cell D4 which is Aug-05 in MMM-YY format
A4 = Jul-05
A5 = Aug 05

B4=1
B5=2

The answer I get is 1, when it should be 3, since I am testing for less than or equal to....

Any advice?

[olasa]

It should work...

Ola