SUMIF Question

[Nigel]

Hi All
I use the SUMIF worksheet function to SUM a range conditionally, eg

SUMIF(A1:A5,"",B1:B5), which works great for summing B1:B5 if any cell in
A1:A5 is blank

I now wish to reverse the logic and sum if any cell in A1:A5 are NOT blank,
but

SUMIF(A:A5,NOT(""),B1:B5) does not work !

Please help

 

[William]

Hi Nigel

Try...
=SUMIF(A1:A5,"<>"&"",B1:B5)
--

XL2003
Regards

William
(e-mail address removed)

 

[Bill Kuunders]

=SUMPRODUCT(--NOT(ISBLANK(A1:A5)),B1:B5)
will do the trick

Or you could take your original formula and deduct that from SUM(B1:B5)

 

[Nigel]

That does the trick - many thanks

 

[Nigel]

Hi Bill
Thanks for the tip - nice elegant solution

Greetings from the UK!!

 

[Tom Ogilvy]

Just to add:

=SUMIF(A1:A5,"<>",B1:B5)

Should be sufficient

 

[Bill Kuunders]

Of course it is
Thanks Tom
Learning each day.
Regards
Bill K