Guys, I need use IFSUM with 2 condictions, how i do?
For exemple: IFSUM(a1:a5;"=OK";b1:b5) AND IFSUM(c1:c5;"=CHECKED";b1:b5)

column:A B C
Line1 OK 1 CHECKED
Line2 NOK 2 CHECKED
Line3 OK 1 NOCHECKED
Line4 NOK 2 NOCHECKED
Line5 OK 1 CHECKED

My result must be: SUM = 2 (lines 1 and 5)

Thanks

=SUMPRODUCT(--(A1:A5="OK"),--(C1:C5="CHECKED");B1:B5)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"IFSUM with 2 condictions" <IFSUM with 2
wrote in message
...
Guys, I need use IFSUM with 2 condictions, how i do?
For exemple: IFSUM(a1:a5;"=OK";b1:b5) AND IFSUM(c1:c5;"=CHECKED";b1:b5)

column:A B C
Line1 OK 1 CHECKED
Line2 NOK 2 CHECKED
Line3 OK 1 NOCHECKED
Line4 NOK 2 NOCHECKED
Line5 OK 1 CHECKED

My result must be: SUM = 2 (lines 1 and 5)

Thanks

=SUMPRODUCT(--(A1:A5="OK");--(C1:C5="CHECKED");B1:B5)


Regards,

Peo sjoblom

"IFSUM with 2 condictions" wrote:

Guys, I need use IFSUM with 2 condictions, how i do?
For exemple: IFSUM(a1:a5;"=OK";b1:b5) AND IFSUM(c1:c5;"=CHECKED";b1:b5)

column:A B C
Line1 OK 1 CHECKED
Line2 NOK 2 CHECKED
Line3 OK 1 NOCHECKED
Line4 NOK 2 NOCHECKED
Line5 OK 1 CHECKED

My result must be: SUM = 2 (lines 1 and 5)

Thanks

=SUMPRODUCT(--(A1:A100="OK"),--(C1:C1000="CHECKED"),B1:B1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"IFSUM with 2 condictions" <IFSUM with 2
wrote in message
...
Guys, I need use IFSUM with 2 condictions, how i do?
For exemple: IFSUM(a1:a5;"=OK";b1:b5) AND IFSUM(c1:c5;"=CHECKED";b1:b5)

column:A B C
Line1 OK 1 CHECKED
Line2 NOK 2 CHECKED
Line3 OK 1 NOCHECKED
Line4 NOK 2 NOCHECKED
Line5 OK 1 CHECKED

My result must be: SUM = 2 (lines 1 and 5)

Thanks