Simple formula - help please

P

PigPOg

Hi, I'm a new to Excel so please excuse my ignorance in advance.

I have data in Column C that I need to multiply with Column D. I know
(for example) I can get a result by placing the formula: =sum(C3*D3)
in cell E3.

But, I have very long columns of data and I don't want to type in
=sum(C4*D4)in cell E4, =sum(C5*D5) in cell E5 etc.

My question is; can I use a wildcard for the column number and then
just paste this formula in each E cell?

Thanks
 
P

PigPOg

Hi, I'm a new to Excel so please excuse my ignorance in advance.

I have data in Column C that I need to multiply with Column D. I know
(for example) I can get a result by placing the formula: =sum(C3*D3)
in cell E3.

But, I have very long columns of data and I don't want to type in
=sum(C4*D4)in cell E4, =sum(C5*D5) in cell E5 etc.

My question is; can I use a wildcard for the column number and then
just paste this formula in each E cell?

Thanks
Click to expand...

Sorry, should have said "... wildcard for the ROW number..."
 
B

Bernard Liengme

Firstly you do not need SUM, the correct formula is =C3*D3
To copy the formula do EITHER
a) click on D3 (cell with formula), put mouse pointer over its lower right
corner (a small blank square called the fill handle). The mouse pointer
changes from an open cross to a +. Drag the mouse to pull the selection
down. The formulas will automatically adjust to =C4*D4, etc.
OR
b) click on D3 (cell with formula), put mouse pointer the fill handle and
double click to fill down (this only works with vertical tables)
best wishes
 
D

Don Guillett

in e4 type =c4*d4 and use the fill handle on the lower right of the cell to
drag down.
 
0

0-0 Wai Wai ^-^

You can simply drag the forumla.
Can you see the small black square at bottom right corner?
Drag towards the end of the data and it is done.
Enjoy :p
 
P

PigPOg

Hi, I'm a new to Excel so please excuse my ignorance in advance.

I have data in Column C that I need to multiply with Column D. I know
(for example) I can get a result by placing the formula: =sum(C3*D3)
in cell E3.

But, I have very long columns of data and I don't want to type in
=sum(C4*D4)in cell E4, =sum(C5*D5) in cell E5 etc.

My question is; can I use a wildcard for the column number and then
just paste this formula in each E cell?

Thanks
Click to expand...


Thanks for the input everyone. It works!

Simon
 
Top