Sum of product

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)




tb wrote:

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;

--

Dave Peterson

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

"tb" wrote:

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;