How do I do a count sum that ignores duplicate items

B

Bob Phillips

=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

If you mean sum, then you need

=SUMPRODUCT(1/(COUNTIF(A1:A100,A1:A100)),A1:A100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Duplicate entry in a column/row 14
How do I use sumifs - 1
delete duplicates 0
Help in counting and summing cells based on multiple conditions 9
How to combine SUMPRODUCT with COUNTIF? 6
Count if 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Counting blank unique entries 5

Top