duplicate values

C

CandiC

I have a spreadsheet that has duplicate values for a series of items
throughout an engineering bill of material. I need to calculate total demand.

Col Item qty
a b
12 5001 2,000
215 5001 1,005
367 5001 6,000

My total Demand for item 2001 is 9,005ea. How can I develp a formula to help
me pull all of the duplicates out and add the total demand?

Thank you,

Candi C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Data from Tables 1
MS Excel Function (Find Duplicate values) 3
Using Formula based Cell Content Return Unique Consecutive Duplicate Values 8
Removing Duplicates Help 6
Query to Count Duplicate Values in a Given Date Range 5
Duplicate and Null values 6
Removing duplicate entries. 2
count values in report 1

Top