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

--
Don Guillett
SalesAid Software

"Nad" wrote in message
...
tried that but it also copies the numbers in that cell?
Thanks


Don Guillett wrote in message
...
After you get the first one have you tried dragging the formula. grab
the
bottom right of the cell.

--
Don Guillett
SalesAid Software

"Nad" wrote in message
...
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