IFSUM with 2 condictions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)> wrote in message
news:[email protected]...
 
=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
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top