What could be wrong with this formula please? It is not throwing an
error, just evaluating to zero. However, the basic data which I have
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 than
sep 30 2005. The range e2:e54 contains amounts.
The range c2:c54 also includes a few blank cells.


--
abanerji
------------------------------------------------------------------------
abanerji's Profile: http://www.excelforum.com/member.php...o&userid=35382
View this thread: http://www.excelforum.com/showthread...hreadid=551513

Hi

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

Hope this helps.
Andy.

"abanerji" wrote in
message ...

What could be wrong with this formula please? It is not throwing an
error, just evaluating to zero. However, the basic data which I have
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 than
sep 30 2005. The range e2:e54 contains amounts.
The range c2:c54 also includes a few blank cells.


--
abanerji
------------------------------------------------------------------------
abanerji's Profile:
http://www.excelforum.com/member.php...o&userid=35382
View this thread: http://www.excelforum.com/showthread...hreadid=551513

Try where A1 contains your date:

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

OR

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

"abanerji" wrote:


What could be wrong with this formula please? It is not throwing an
error, just evaluating to zero. However, the basic data which I have
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 than
sep 30 2005. The range e2:e54 contains amounts.
The range c2:c54 also includes a few blank cells.


--
abanerji
------------------------------------------------------------------------
abanerji's Profile: http://www.excelforum.com/member.php...o&userid=35382
View this thread: http://www.excelforum.com/showthread...hreadid=551513

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551513

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

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


--
abanerji
------------------------------------------------------------------------
abanerji's Profile: http://www.excelforum.com/member.php...o&userid=35382
View this thread: http://www.excelforum.com/showthread...hreadid=551513

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

"abanerji" wrote:


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

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


--
abanerji
------------------------------------------------------------------------
abanerji's Profile: http://www.excelforum.com/member.php...o&userid=35382
View this thread: http://www.excelforum.com/showthread...hreadid=551513