Forum Discussion
Solved
Using the UNIQUE and COUNTIFS function to count cells matching multiple criteria
Hello there, I am struggling in finding a way to use the COUNTIFS function to count the number of cells (ASVs) that are unique and are classified as "active". Below is my best attempt thus far wh...
=COUNTA(UNIQUE(FILTER(D2:D24,(E2:E24="active"))))If you don't mind applying COUNTA instead of COUNTIFS you can try this formula.
=COUNTA(UNIQUE(FILTER(D2:D24,(E2:E24="active"))))If you don't mind applying COUNTA instead of COUNTIFS you can try this formula.
Works like a charm! Thank you!