How do I make a formula work for all the cells in a column?

J

Janelle

Hi,

How do I make a formula work for an entire column without having to input
each row, one at a time? Each cell in the column would be calculating from
another columns entry. I currently am inputting it like this.....

D1: =SUM(C1)-1
D2: =SUM(C2)-1
D3: =SUM(C3)-1

Is there a way for me to set the formula for the entire column eventhough it
has to reference a new cell from another column each time (as in the example
above)?

Any help would be greatly appreciated!!! =)
 
L

Lars-Åke Aspelin

Hi,

How do I make a formula work for an entire column without having to input
each row, one at a time? Each cell in the column would be calculating from
another columns entry. I currently am inputting it like this.....

D1: =SUM(C1)-1
D2: =SUM(C2)-1
D3: =SUM(C3)-1

Is there a way for me to set the formula for the entire column eventhough it
has to reference a new cell from another column each time (as in the example
above)?

Any help would be greatly appreciated!!! =)

Just put the formula in cell D1.
Then double click on the little square handle in the lower right
corner of cell D1.
The formula will automagically be filled down column D as far as you
have data in column C.
You can also "click and hold" this handle and then drag it down as far
as you need before you "unclick" it.

Hope this helps / Lars-Åke
 
B

Bob Phillips

Just enter it in D1, then move the cursor towards the bottom right corner of
the cell until it changes to a black cross. Then, whilst holding down the
left-mouse button, drag and copy the formula down as far as required.

HTH

Bob
 
L

Leah

Janelle said:
Hi,

How do I make a formula work for an entire column without having to input
each row, one at a time? Each cell in the column would be calculating from
another columns entry. I currently am inputting it like this.....

D1: =SUM(C1)-1
D2: =SUM(C2)-1
D3: =SUM(C3)-1

Is there a way for me to set the formula for the entire column eventhough it
has to reference a new cell from another column each time (as in the example
above)?

Any help would be greatly appreciated!!! =)

If you look at the active cell you should see a little square in the outline
on the bottom right corner of the cell. If you hover over the square your
cursor will change to a little cross. You can click that box and drag it
down the entire column/row. The formula will copy over and the cells will be
updated like you want.
 
G

Gord Dibben

You have fill handle answers in other replies.

Just to make your life a little easier.......

=SUM(C1)-1 can be written =C1-1

SUM is used when multiple cells are to be summed.

i.e. =SUM(C1:C10) or =SUM(C1,C4,C6,C8,C10)


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top