Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF(SUM) help please | Excel Worksheet Functions |