ExcelBanter - How do I do a count sum that ignores duplicate items

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I do a count sum that ignores duplicate items (https://www.excelbanter.com/excel-worksheet-functions/13626-how-do-i-do-count-sum-ignores-duplicate-items.html)

Robin Faulkner

How do I do a count sum that ignores duplicate items

Bob Phillips

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

--

HTH

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

"Robin Faulkner" <Robin wrote in message
...

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)

"Bob Phillips" wrote in message
...
=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

--

HTH

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

"Robin Faulkner" <Robin wrote in
message
...

All times are GMT +1. The time now is 03:18 PM.