Jun 14 2022 12:34 PM
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!
Jun 14 2022 01:11 PM
Solution=COUNTA(UNIQUE(FILTER(D2:D24,(E2:E24="active"))))
If you don't mind applying COUNTA instead of COUNTIFS you can try this formula.
Jun 14 2022 01:38 PM
Jun 14 2022 01:11 PM
Solution=COUNTA(UNIQUE(FILTER(D2:D24,(E2:E24="active"))))
If you don't mind applying COUNTA instead of COUNTIFS you can try this formula.