Sum of 2 columns

  • Thread starter Thread starter Mediaexcel
  • Start date Start date
M

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
 
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
 
Back
Top