SUM Range based on non-specific text

[whathuh]

Hi - I'm sure this has been addressed SOMEWHERE in the messageboard, so I apologize for the redundancy. I may be going about this all wrong, so that could be why I'm running into difficulties finding it on the site.

I have a column with numbers and a column with dates or blanks...

1 8-Aug-10
1
5 15-Aug-10
8
10
1 2-Aug-10
1

I want to total the cells in A where B contains a date. But it doesn't even have to be a date - just any non-specific string. Currently, this what I have:

=SUMIF(B2:B291,"x",A2:A291)

But I have to have a column next to date and put an "x" in the row I want totaled. If I put "2-Aug-10", it works fine, too, but then it won't total the dates that aren't specifically 2-Aug-10. So basically, if I can just total the column based on non-blank adjacent cells OR date-specific cells, I would be very appreciative. Thanks ;]

-Adam

 

[VoG]

Try this - change the ranges to suit

=SUMIF(B1:B10,"<>",A1:A10)

 

[whathuh]

Outstanding! That is perfect. I kept looking for how to insert wildcards, but nothin' was working. That worked - thank you so much.