Sumif formula not giving result

[abanerji]

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.

Hi

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

Hope this helps.
Andy.

"abanerji" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bearacade]

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

[Toppers]

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
>
>

[abanerji]

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.

[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

"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
>
>