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
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