Sumif formula not giving result

[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

 

[Guest]

Hi

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

Hope this helps.
Andy.

 

[Guest]

Try where A1 contains your date:

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

OR

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

 

[Bearacade]

=sumif($c2:$c54,">"&date(2005,9,30),e2:e54

 

[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

 

[Guest]

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