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" 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" 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 worksheetsNext: Help with Table, Please!