Simple formula - help please

[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

 

[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

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

 

[KL]

Just copy your first formula and paste it down.

Regards,
KL

 

[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

 

[Don Guillett]

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

 

[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

 

[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

Thanks for the input everyone. It works!

Simon

 

[Don Guillett]

we're all glad to help.