Forum Discussion
Excel CountIf, plus second statement
I have two columns of data, please note not all rows have data inputted (i.e. Row 1 could have data in Column 1&2, Row 2 has data in Column 1 but not Column 2, and Row 3 has data in Column 2 but not ...
=COUNTIFS(A2:A1000, "AB", B2:B1000, ">0")
Adjust the ranges as needed (it doesn't matter if they include more cells than are in use).