Sumif, having two condition
 

I want to use the function sumif. but I have two condition.

sumif(sheet1!a2:a100, sheet2!B2, Sheet1!D2:D100)
based on this, I want to add that when Sheet1!a2:a100 = Sheet2!B2, the value
on that row of column C must be larger than zero.

How can I do?

Thanks at advanced!

Sumif, having two condition
 

=SUMPRODUCT(--(Sheet1!A2:A100=Sheet2!B2),--(Sheet1!C2:C1000),Sheet1!D2:D100)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ViestaWu" wrote in message
...
I want to use the function sumif. but I have two condition.

sumif(sheet1!a2:a100, sheet2!B2, Sheet1!D2:D100)
based on this, I want to add that when Sheet1!a2:a100 = Sheet2!B2, the
value
on that row of column C must be larger than zero.

How can I do?

Thanks at advanced!

Sumif, having two condition
 

Hi

=SUMPRODUCT((Sheet1!$A$2:$A$100=Sheet2!$B$2)*
(Sheet1!$C$2:$C$1000)*Sheet1!$C$2:$C$100)

--
Regards

Roger Govier


"ViestaWu" wrote in message
...
I want to use the function sumif. but I have two condition.

sumif(sheet1!a2:a100, sheet2!B2, Sheet1!D2:D100)
based on this, I want to add that when Sheet1!a2:a100 = Sheet2!B2, the
value
on that row of column C must be larger than zero.

How can I do?

Thanks at advanced!