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

Duplicate and Null values 6
How to get the latest data from a workbook 3
Excel Solved - Using Excel 2007 Large()/Small() function without duplicate values! 1
Attn Sprinks- Not duplicate insert records 1
History of Xbox 360 defects - Dean Takahashi has the inside story(long) 2
Living With a Computer 3
Beyond3D article on ATI 'Xenos' - the graphics processor of Xbox 360 1
FWT Newsletter - Weekly - October 4, 2004 2

Top