sumif

[Guest]

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

 

[Trevor Shuttleworth]

=SUMIF(B:B,"<>",A:A)

Regards

Trevor

 

[Guest]

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