Counting Unique Values in Excel

Last updated at August 14, 2026 by

In this case,we have to use

=SUMPRODUCT(1/COUNTIF(SELECT RANGE,CRITERIA))

 

Note:-

HERE,

Range and Criteria are same,hence Formula actually is

=SUMPRODUCT(1/COUNTIF(SELECT RANGE,SELECT RANGE))

EXAMPLE

 

Counting Unique Values in Excel - Count Formulas

 

 Download file and try

Countif for counting duplicates.xlsx
View Answer
Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.