sumif

[PointerDog]

I am having a problem with sumif function. C2 = 5/20/11

This does not work:
=SUMIF(C5:C900,"<c2",B5:B900)

This does work:
=SUMIF(C5:C900,"<5/20/11",B5:B900)

I would like to use the first option. What am I doing wrong?

 

[shadow12345]

err i don't you whole formula showed up.....

=SUMIF(C5:C900," wouldn't work beceause its not finished. (i had this problem yesterday on the board, try adding some spaces before what ever comes after =SUMIF(C5:C900,"

 

[Jonmo1]

It's the < and/or > symbols
The board software thinks they are html code

When posting a formula, put spaces before and after each of those symbols...


Now, I'm guessing what you're trying to do is

=SUMIF(C5:C900," < C2",B5:B900)

Try

=SUMIF(C5:C900," < "&C2,B5:B900)

 

[shadow12345]

ahhhhhhh thats what made it go loopy last night. I worked it out in the end but still good to know its not just me.

 

[Jonmo1]

ahhhhhhh thats what made it go loopy last night. I worked it out in the end but still good to know its not just me.

Yes, it's very goofy. For some reason it doesn't always do it, only certain situations.

 

[PointerDog]

Thanks to both of you. =SUMIF(C5:C900," < "&C2,B5:B900) --- worked perfectly. Plus I learned something on posting. This is a great site.