Microsoft Microsoft excel 2007 full vers...

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.

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 thisHow-To.

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

Helmut, First, your suggested formula of

A1*Bis 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 2He 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 thisHow-To.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History