Multiplying two columns

R

retarded

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....
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
retarded said:
How do I multiply column A (length) by column B (width)? All I want
Click to expand...
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....
 
Top