Function Help

B

brittonsm

I am trying to count the number of unique suppliers in a column that
exist on a list on Sheet 2 - I can get it to count unique, but when I
use the criteria of the other list I get a #DIV/0! Error.

[These are both array formulas]

This counts unique records:

=SUMPRODUCT((T10:T2104<>"")/COUNTIF(T10:T2104,T10:T2104&""))

This bombs:

=SUMPRODUCT((T10:T2104<>"")/COUNTIF(T10:T2104,'Current Supplier'!
A2:A2287&""))
 

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

Count Number of Unique Cells That Don't Have Certain Characters 0
countif - unique values only 13
Trouble with cell value 4
Formula for average of cells that have blanks 1
Elementary SUMPRODUCT Question 3
AdvancedFilter syntax 2
=Sumproduct Question 0
Need some PWA help 0

Top