Copy Cell Sum

[Nad]

How do i copy a cells format. I have got a cell which adds up a whole
column, what I would like
is other columns to do the same but there must be an easier way of doing it
without clicking the bottom of each
column and then clicking the sum tool? can i copy this function?
Thanks

 

[Don Guillett]

After you get the first one have you tried dragging the formula. grab the
bottom right of the cell.

 

[RagDyer]

With relative references being used (no $ in cell addresses), simply click
on the "fill handle" of the cell containing the original formula, and drag
across the columns to automatically copy the formula as far as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do i copy a cells format. I have got a cell which adds up a whole
column, what I would like
is other columns to do the same but there must be an easier way of doing it
without clicking the bottom of each
column and then clicking the sum tool? can i copy this function?
Thanks

 

[Nad]

tried that but it also copies the numbers in that cell?
Thanks

 

[Don Guillett]

use
=sum(a2:a200) and drag that to b c d e etc

 

[Nad]

dose not work

 

[RagDyer]

Would you post the *exact* formula you're trying to copy?
--


Regards,

RD

 

[CarlosAntenna]

After you copy, press F9 to recalculate. Or set calculation to automatic.
(tools>options>calculation tab>automatic)

Carlos

 

[Nad]

all done, thank you all

Would you post the *exact* formula you're trying to copy?
--


Regards,

RD