SUM Range based on non-specific text

whathuh

New Member
Joined
Aug 12, 2010
Messages
2
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try this - change the ranges to suit

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

whathuh

New Member
Joined
Aug 12, 2010
Messages
2
Outstanding! That is perfect. I kept looking for how to insert wildcards, but nothin' was working. That worked - thank you so much.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,574
Messages
5,573,009
Members
412,495
Latest member
CoolerOconnor
Top