Sumif formula not giving result

A

abanerji

What could be wrong with this formula please? It is not throwing a
error, just evaluating to zero. However, the basic data which I hav
should return a positive number. The formula is

=SUMIF($C2:$C54,">date(2005,9,30)",E2:E54)

The range c2:c54 contains valid dates some of which are greater tha
sep 30 2005. The range e2:e54 contains amounts.
The range c2:c54 also includes a few blank cells
 
T

Toppers

Try where A1 contains your date:

=SUMIF($C2:$C53,">" & A1,E2:E53)

OR

=SUMIF($C2:$C53,">25/9/2005",E2:E53)
 
A

abanerji

Thank you Toppers. I tried your second alternative ... it worked.

But, I am still academically curious as to why m
"date(year,month,day)" function inserted within the formula failed t
evaluate.
I think I have successfully embedded functions within other formula
several times in the past
 
T

Toppers

See the other responses but the ">date(...)" is treated as a text string
whereas the ">" & date( ...) is treated as comparator + function in the same
way that you can use ">" & A1.

HTH
 
Top