Multiplying two columns

[Guest]

How do I multiply column A (length) by column B (width)? All I want is a new column C (area) where the cells correspond to what I just multiplied if one were to look from left to right. A x B = C. I can do it for two numbers but not whole columns....

 

[Norman Harker]

In (eg) C1

=A1*B1

Select C1
Point to bottom right corner until you see the plus
Double click

To get the sum of all A*B you can use:

=SUMPRODUCT(A1:A50,B1:B50)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

How do I multiply column A (length) by column B (width)? All I want

is a new column C (area) where the cells correspond to what I just
multiplied if one were to look from left to right. A x B = C. I can
do it for two numbers but not whole columns....