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 you have read our privacy policy.

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