# Sum without repetition

1. ## Sum without repetition

I have an excel file with two sheets. The first sheet contains raw data received from barcode readers at my factory workshop. The second sheet is where I want to prepare a report using the data in the first sheet.

Each product is scanned at every station it passes through. So in the raw data, each product will be mentioned multiple times depending on how many stations it had to go to. What i want to do is calculate the total area produced, but in this calculation I cannot just use "sum", because then I will be adding the area of the products maybe twice or three times depending on how many times the product was repeated in the data. So I want to add the area of each product without repeating it again.

I know it sounds simple and confusing at the same time, thats why I have add a sample to make my case clear.

Awaiting your kind assistance.

2. ## Re: Advanced formulas and functions

Hi ratkiller,

Have you considered doing a sumif divided by a countif? This would give you the average values of each product, but since the values are the same each time, you would just get the exact values.

3. ## Re: Advanced formulas and functions

ratkiller,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

4. ## Re: Advanced formulas and functions

I tried your suggestion, but I wasn't able to get it right. Maybe you can help me with the syntax? give me an example

5. ## Re: Sum without repetition

So for "Square to round" should it be divided by the to unique values =SUM(0.706+0.434) + all other constraints.
//Ola

6. ## Re: Sum without repetition

I got it, first I added a new column and made a specific reference for each item. then I used the following formula

=(SUM(1/COUNTIF(\$V\$2:\$V\$10,\$V\$2:\$V\$10)))*M10

this gave me the total area of each item without repeating it.

If anyone wants the excel file to see how it works, please msg me.

##### Users Browsing this Thread

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