If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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; |
#2
|
|||
|
|||
Sum of product
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 |
#3
|
|||
|
|||
Sum of product
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; |
Thread Tools | |
Display Modes | |
|
|