Sum of 2 columns

[Mediaexcel]

This may be easy but my brain just isn't working today! Here goes:


I have to multiply values for column A with Column B and show the gran
total at the end of column B. Same thing again with column A*Column
and Total at the end of column C and so on.

Now I know I can add an additional column use the sum formula and ge
the total , however I will end up having to many columns.

Currently I am using the following formulain cell G51 to get the total
(Its pretty long!)

SUM($A10*G10)+($A11*G11)+($A12*G12)....+($A50*G50)

Is there a smaller formula to multiply both columns and have the sum
at the end.

Thank yo

 

[Domenic]

Hi,

For simplicity sake, let's assume that your spreadsheet contains dat
in the first ten rows, and that you want your totals in row eleven:

B11, copied across:

=SUMPRODUCT($A$1:$A$10,B1:B10)

Hope this helps

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(A10:A50,G10:G50)

 

[Mediaexcel]

Thank you Frank