IFSUM with 2 condictions

[IFSUM with 2 condictions]

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

[Bob Phillips]

=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
[email protected]> wrote in message
news:[email protected]...
> 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

[Peo Sjoblom]

=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

[Bob Phillips]

=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
[email protected]> wrote in message
news:[email protected]...
> 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