sumif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Todd L. - 23 Jun 2007 00:15 GMT

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

Reply to this Message

Trevor Shuttleworth - 23 Jun 2007 00:32 GMT

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

Regards

Trevor

> Hi,
>
[quoted text clipped - 13 lines]
>
> Todd

Reply to this Message

Ron Coderre - 23 Jun 2007 00:37 GMT

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

> Hi,
>
[quoted text clipped - 13 lines]
>
> Todd

Reply to this Message