Countif distindt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. Please, is there some formula i can use to do count distinct of a
range of cells? This would help to eliminate duplicates when counting, I can
do this using the pivot table but it would be great to have this as formula
to avoid many steps. Thanks
 
One way

=SUMPRODUCT(--(A1:A10<>""),1/COUNTIF(A1:A10,A1:A10&""))


will do a distinct count in A1:A10
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
=Countif(range, criteria) 2
Counting number of items excluding duplicates. 1
COUNT function - # of occurences a number appears in all cells 26
Defining a Range with Criteria 2
Highlight exact match in column and count 2
countif when 2 values in a cell 9
Please help with countif formula 4

Back
Top