1. Excel
  2. Count Formulas
Check sibling questions

Counting Unique Values in Excel

Last updated at Dec. 13, 2024 by Teachoo

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

 

 

 Download file and try

Countif for counting duplicates.xlsx

View answer

For Question 1: To Calculate how many subjects.

 

We can make a pivot table and count the subjects.
or 

We can use countif and sumproduct formula



-ea-

  1. Excel

    2. Count Formulas

    Sumif and Sumifs →
Sumif and Sumifs →
Accounts Tax
Excel

About the Author

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.