Sum of product

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;
 
D

Dave Peterson

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)
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtracting multiple columns from another column 3
Looking formula that SUM values with specific value in neighboring colum 2
Excel Excel Formula OFFSET maybe? 1
Referrence a total in a cell on another worksheet 4
how do I specify a date range = date(2010,4,1 thru 30) 1
Sum a license total, then vlookup to determine training cost 11
sum value of nonblank discontinuous cells 3
using data from one worksheet in another worksheet 1

Top