getting totals mutiply cell by another cell then adding all togeth

[texansgal]

I am trying to get weights on a Spreadsheet.

cell A33 has a qty of 5
cell C33 is the weight of 900 lbs
add
cell A34 - qty of 4
cell C34 is the weight of 500 lbs

I need to take all of the Qtys (column A, rows 33-41) and multiply them by
the unit weight (column C, rows 33-41) for a total weight in C43.

Please help... I am going crazy with this workbook...

Thank you,
Vanessa

 

[T. Valko]

Try this:

=SUMPRODUCT(A33:A41,C33:C41)

 

[texansgal]

Thank you so much!

Try this:

=SUMPRODUCT(A33:A41,C33:C41)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you so much!