sumif

T

Todd L.

Hi,

I am trying to create a formula that sums the information in a column if
matching cell in a different column isn't blank.


For Example
The result below would be 2.

Column A Column B
1 5002
2
1 5003
1




Thanks for the help!


Todd
 
R

Ron Coderre

Try something like this:

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

Note: Excel automatically expands the range-to-sum to match the search range.
The above example is the same as =SUMIF(B1:B10,"<>"&"",A1:A10)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top