web analytics

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

 

Countif formula for counting duplicates - Count Formulas

 

 Download file and try

View Answer
  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail