Simple formula - help please

  • Thread starter Thread starter PigPOg
  • Start date Start date
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
 
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..."
 
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
 
in e4 type =c4*d4 and use the fill handle on the lower right of the cell to
drag down.
 
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
 
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
 
Back
Top