Hello,
I am trying to figure out a way to get a count if certain criteria's are met including an AND function. Is this possible? Example: I am trying to get a count if Column B & C both do not equal "0", Column A equals "GC", and Column D equals "Active". Is this possible? I currently tried IF(AND(B:B<>0,C:C<>0),COUNTIFS(A:A,"GC",D:D,"Active"))
Outcome should be "2"
<tbody>
</tbody>
I am trying to figure out a way to get a count if certain criteria's are met including an AND function. Is this possible? Example: I am trying to get a count if Column B & C both do not equal "0", Column A equals "GC", and Column D equals "Active". Is this possible? I currently tried IF(AND(B:B<>0,C:C<>0),COUNTIFS(A:A,"GC",D:D,"Active"))
Outcome should be "2"
Group | # of A Drawing | # of X Drawing | Status |
GC | 0 | 0 | Active |
PC | 2 | 1 | Complete |
AV | 0 | 6 | Active |
GC | 6 | 4 | Complete |
SI | 4 | 0 | Complete |
SI | 5 | 8 | Active |
GC | 5 | 0 | Active |
GC | 1 | 1 | Active |
<tbody>
</tbody>