SUMIF
 

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

One way:

=SUMPRODUCT(--ISBLANK(A1:A100),--(B1:B1000),C1:C100)

See

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

for an explanation of the "--".


In article ,
BOB wrote:

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