# I need help with a Sum Formula

1. ## I need help with a Sum Formula

Can anyone 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 bellow.

94600
94655
94666
94666
94666
94666
94689
94691

The reason some order numbers multiply is that the spread sheet also shows what items were ordered and so one order might have 4 items on it, hence the repeat in numbers.

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

I guess another way of putting it is I what excel to tell me is how may orders came through in a month so readers of the spreadsheet can see that out of the 100 numbers in that column, there's actually only 65 orders, not 100.

Cheers

2. ## Re: Excel Sum Formula

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Thread has been moved to the correct section.

3. ## Re: I need help with a Sum Formula

I suppose they changed the title from "Excel Sum Formula" to "I need help with a Sum Formula".
I imagine this may not be enough and we are looking for something more like "Summing of unique items in a list" or "A sum that includes only items where value changes".
(Side note -the poster should also consider if this request is a robust approach.)

* hoping that assistance in resolving the infraction is not an infraction in itself!

4. ## Re: I need help with a Sum Formula

Thanks for the help with the title, which is perfectly fine at this juncture.

5. ## Re: I need help with a Sum Formula

Sorry - what I said was that helping with the title was OK, nothing else. We now wait for the OP to change it.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1