duplicate values

  • Thread starter Thread starter CandiC
  • Start date Start date
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
 
Try this...

C1 = item to sum = 5001

D1 = formula:

=SUMIF(A:A,C1,B:B)
 
You must log in or register to reply here.

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

calculating value in a query 1
Duplicate and Null values 6
VLOOKUP Function returning multiple values in a separate table 8
Sum Values when Duplicate ID Exists 2
Depreciation Formula 2
How to pick a value out of a table 2
How to get the latest data from a workbook 3
Can an update query return a calculated value to a select query? 2

Back
Top