SUMIF

[BOB]

Hi

Help, I have 3 columns of data and need to sum on Column C if the Value is
column A is Blank and the Value in column B is >0

For example

A B C
1 2
1 1 5
2 2
2 7

Therefore my formula needs to return the value of 4

Thanks, Phil

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--ISBLANK(A1:A100),--(B1:B100>0),C1:C100)

See

http://www.mcgimpsey.com/excel/doubleneg.html

for an explanation of the "--".