Skip to content

Count Unique Values in Google Sheets

Did you know that there is a super easy way to get a count of unique values in Google Sheets?

All you have to do is use the COUNTUNIQUE function!


The COUNTUNIQUE function counts the number of unique values in a list of specified values and ranges.

Take a look at the list of colors below.

You can use the following formula to count how many unique colors there are.


The COUNTUNIQUE function references the range of cells containing colors and returns a count of how many unique values it finds.

It’s really as easy as 1, 2, 3.

So the next time you need to count the number of unique values in Google Sheets, you are fully prepared to do so!

This Post Has One Comment

  1. I didn’t know this was a thing! This is actually going to be super helpful in checking some of the spreadsheets I get from others to make sure there isn’t anything messed up! I love learning new stuff here!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top