countif not the same

  • Thread starter Thread starter Andrew@rushington
  • Start date Start date
A

Andrew@rushington

can i use countif to count the how many different values exist in a column.
 
can i use countif to count the how many different values exist in a column.
Click to expand...

Assume Col A you want to count a list of uniques (excluding blanks)
within A1:A1000:

=SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&""))

Richard
 
You must log in or register to reply here.

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
How do I do a conditional CountIf function 1
countif with two criteria one a column of dates? 3
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
CountIf Dynamic 4
Countif Problem 3
Count If value 10

Back
Top