I'd like to count unique string values on a filtered list (For example, the value should be 3 in this screenshot):

enter image description here

How can this be done in google sheets?

Here's the spreadsheet: https://docs.google.com/spreadsheets/d/1O1rZUstDNSXPdUVXvaDfPO4rAQs2cJWHimfGxbddtNU/edit#gid=0

2 Answers 2

  • you will need a helper column with SUBTOTAL to evaluate hidden rows
  • expand/cancel your filter
  • paste this in C3 cell and drag down:

    =SUBTOTAL(103, B3)

  • then paste this into B1 cell:




Use UNIQUE to get a list of unique values then COUNTA to count those values. You could even nest them:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.