I am looking for a formula to get a unique count of rows, but only the rows meeting certain criteria should be counted. The criteria value is in another column.
See the sample sheet. I have provided the answer and also how I got the answer using multiple manual steps. Is there a way to automate all that in a single formula?
Solution:
This is a Google sheets solution. Unfortunately, there is one COUNTUNIQUE formula that is exclusive to Google sheets and does not work in MS Excel.
Col C has indicator which is blank or N. We only want to count rows which do not have N
Col D has actual email address. But it can be blank. We only want rows which have an email address, so not blank.
Col A has the last name.
The minus 1 at the end is to eliminate counting 0 which is for rows that do not match the above criteria.
Bookmarks