| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I do a count sum that ignores duplicate items
|
|
#2
|
|||
|
|||
|
=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))
-- HTH RP (remove nothere from the email address if mailing direct) "Robin Faulkner" <Robin wrote in message ... |
|
#3
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| Count If Formula | Excel Worksheet Functions | |||
| get count of row without duplicate entries | Excel Worksheet Functions | |||
Linear Mode
