Prev: Linking worksheets
Next: Help with Table, Please!
From: CandiC on 18 Feb 2010 14:19
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

From: T. Valko on 18 Feb 2010 14:39
Try this...

C1 = item to sum = 5001

D1 = formula:

=SUMIF(A:A,C1,B:B)

--
Biff
Microsoft Excel MVP


"CandiC" <CandiC(a)discussions.microsoft.com> wrote in message
news:ECD33881-8EF9-40B5-BA9B-E12CA1D150B9(a)microsoft.com...
> 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
>


From: Per Jessen on 18 Feb 2010 14:43
HI

=SUMIF(A1:A1000,5001,B1:B1000)

Regards,
Per

"CandiC" <CandiC(a)discussions.microsoft.com> skrev i meddelelsen
news:ECD33881-8EF9-40B5-BA9B-E12CA1D150B9(a)microsoft.com...
> 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
>
 | 
Pages: 1
Prev: Linking worksheets
Next: Help with Table, Please!