value 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:B100>0),C1:C100)

See

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

for an explanation of the "--".


In article <[email protected]>,
BOB <[email protected]> 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