Excel Help needed please-how to sum up?

Microsoft Microsoft excel 2007 full vers...
December 9, 2010 at 06:03:57
Specs: window 2000
Hello in my first post I said I wanted to count, that was wrong. I have been trying really hard to make this work and have been trying to use the sum freatures I'm trying to total the amount ordered of each product type. In column A I have product type in the next column B is the amount ordered. I need to have the total amount of the same products added and place in my total cell for that product. So if one product was orderd 10 times in the month and each order was 30 total would be 300.


See More: Excel Help needed please-how to sum up?

Report •

#1
December 9, 2010 at 07:18:39
Look at the SUMIF function in the Excel Help files.

SUMIF allows you to sum the corresponding values in one column based on specific data in a different column.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

#2
December 9, 2010 at 17:31:21
Do a third column and use the formula A1*B so what appears in the cell in the third column is the product of the numbers in Cell A1 times Cell B1.
You don't want the sum feature you want multiply the two numbers in the cells

Report •

#3
December 9, 2010 at 17:51:05
Helmut,

First, your suggested formula of A1*B is not valid.

Second, reread the OP's question. If I'm not mistaken he has something like this:

     A         B
1  Prod_A      3
2  Prod_B      4 
3  Prod_A      6
4  Prod_A      3
5  Prod_B      2

He is looking for the total number of each product ordered.

=SUMIF(A1:A5, "Prod_A", B1:B5) will return 12

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question