Easily count all distinct values in a range in Excel

Combining the SUM or SUMPRODUCT function and the COUNTIF functions can help count all distinct values (all the different values) in a list in Excel. However, it may be time-consuming and difficult for those formula newbies. Here, we recommend a handy tool – the Count cells with unique values (include the first duplicate value) feature of Kutools for Excel. With this feature, you can easily count all distinct values in a column range with only several clicks.