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 which returns the column of cells highlighted in light blue:
=COUNTIFS(D2:D24, UNIQUE(D2:D24), E2:E24, "=active")
Any help or guidance would be appreciated!
=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!
