Sums

  • Thread starter Thread starter Natalie
  • Start date Start date
N

Natalie

Hi,

I have a table of data, and want to create a new sheet adding it up -

Part no Qty
670 1
56 6
98 2
670 3
98 4

And I want to create a new sheet for

Part no total qty
670
56
98

Can anyone help? I have done this before but I can't remember!

Thanks v much
 
Hi,
you have sheet 1 with the information starting in cell A3, in sheet 2 column
A you have the parts #, starting in A3, in B3 enter

=sumproduct(--(A3=sheet1!$A$3:$A$1000),sheet1!$B$3:$B$1000)

if you are using excel 2007

=sumproduct(--(A3=sheet1!A:A),sheet1!B:B)

if you use the first formula change the range to fit your needs but be sure
that you have the same range in both sides of the formula
 
Back
Top