I am going to count rows based on the values of two columns (i.e., count if the Priority is "1" and Status is "not defined"). Here is an example:
| Priority | Status |
|---|---|
| 1 | implemented |
| 0 | implemented |
| 1 | not defined |
| 0 | not defined |
| 0 | implemented |
| 1 | not defined |
| 1 | implemented |
| 1 | implemented |
which I would like to get 2 because there are only two rows with Priority = 1 and Status = "not defined".
I tried the following but not successful in this regard:
=SUMPRODUCT((COUNTA(M3:M20))*(J3:J20="not defined"))
>Solution :
Use either of the one, refer image
=SUMPRODUCT(($A$2:$A$9=1)*($B$2:$B$9="not defined"))
=COUNTIFS($A$2:$A$9,1,$B$2:$B$9,"not defined")
