Table Question

My table is as follows:

A B C … H
Desc Value Pcs per Qty
1 Widget A 2 1
2 Widget A 2 2
3 Widget A 2 3
4 Widget B 1 1
5 Widget C 3 2
6 Widget C 2 3


If the columns A, B, and C were constant and never changed and only column H changes from job to job, how do I:

SUM the TOTAL number of pieces (pcs per X qty) if the value in column B is "A"?

I need to do this without creating a seperate mutliplication column for the sum of the pieces. It all needs to be done without adding any new columns.

Help!

Thanks,

Brett

Have a look at Sumif() function in Excel Help file.. I think that is what you want...

Originally Posted by BrettOlbrys

Correct me if I am wrong, but the last argument of the SUMIF statement is the Sum-range, which are the cells to sum. The problem I am having is that I am simply not summarizing a group of cells, I have to first multiply two columns together to get a value and that would be the argument that gets summed, but I cannot add a column to do the multiplication, it has to be within the SUMIF formula. How do I do multiplication within a SUMIF formula?

Thanks

Yes, then Sumproduct would be the alternative.

=Sumproduct(--($B$1:$B$100="Widget A"),$C$1:$C$100,$H$1:$H$100)

This sums the products of column C and H...

the result would be repeated everytime Widget A appears in column A.. is that what you wanted...