Sum of product

  • Thread starter Thread starter tb
  • Start date Start date
T

tb

I am trying to find a formula to total a specific product from a list into
another worksheet for totals.

Can i use a LOOKUP formula to look for that specific product and give me
totals for the year in another worksheet?

Thanks;
 
If there were only one entry, then I bet you could.

But if there is more than one entry, you can use =sumif()

=sumif(sheet2!a:a,"product1",sheet2!b:b)
 
Hi,
your data is in sheet2 column A product name column B amount, in sheet1 you
have in column A the product name and you want the totals in columnB so enter

=sumproduct(--(A1=sheet2$A$1:$A$10000),$B$1:$B$10000)

copy formula down, change range to fit your requirements, range has to be
the same in both sides of the formula
 
Back
Top