Can someone help me witha sum formula

[Colinology]

Hi everyone,

Can someone help me with a sum formula for Excel?

I have a column with a series of order numbers from my client, lets say about 100.
Some of the order numbers are the same so lets say 65 of them are unique and the other 35 are doubles or triples etc as per the example below.

94600
94655
94666
94666
94666
94689
94691

The reason some of these numbers multiply is that the spread sheet also shows what items have been ordered and so one order might have 4 items on it, hence the repeated numbers.

Is there a sum that will add up the unique numbers only and not the doubles?

Thanks for your help.

Cheers

 

[fhqwgads]

=SUMPRODUCT(1/COUNTIF(A1:A7,A1:A7&""),A1:A7)

replace A1:A7 with whatever your range is
hope that works

 

[Aladin Akyurek]

This gives you a distinct/unique count of order numbers:

=SUM((FREQUENCY(A1:A7,A1:A7)>0)+0)

 

[Joyner]

Hello, are you looking for a formula solution? If not, do you have power query (get and transform), if so, you can solve this fairly quickly.