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

View Answer
Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.