how do I get the columns to add up as I go along
 

I am working on a spread sheet for yearly figures but do not know how to get
the columns to add up as I am going along. Could anyone please help with this

how do I get the columns to add up as I go along
 

Hi Lynne

Supposing you have Jan through to Dec in B1:M1, with Total in N1
In cell N2 enter
=SUM(B2:M2)

As you add figures into any of the month columns, the Total in column N will
reflect those figures
Copy the formula down column N as far as required.
The easiest way to do this is to use the "fill handle". Hover your cursor
over the bottom right of cell N2 after you have entered the formula, until a
small black cross appears. Left click and drag down as far as you require,
then release the mouse button. The formula will have been copied down and
adjusted to the new row numbers.


--
Regards
Roger Govier



"Lynne" wrote in message
...
I am working on a spread sheet for yearly figures but do not know how to
get
the columns to add up as I am going along. Could anyone please help with
this

how do I get the columns to add up as I go along
 

"Lynne" wrote in message
...
I am working on a spread sheet for yearly figures but do not know how to
get
the columns to add up as I am going along. Could anyone please help with
this

Perhaps you could explain what you want to happen. If you have a formula
such as =SUM(A1:A12), this will add up the cells in the range A1:A12 as you
populate them. Presumably this is not what you want, so we need to
understand your requirement.

Stephen

how do I get the columns to add up as I go along
 

Stephen wrote on Mon, 15 Oct 2007 10:02:21 +0100:

S "Lynne" wrote in message
S ...
?? I am working on a spread sheet for yearly figures but do
?? not know how to get the columns to add up as I am going
?? along. Could anyone please help with this

S Perhaps you could explain what you want to happen. If you
S have a formula such as =SUM(A1:A12), this will add up the
S cells in the range A1:A12 as you populate them. Presumably
this
S is not what you want, so we need to understand your
S requirement.

Are you perhaps trying to get a running total as you add lines
in the spreadsheet? In that case, you might want to keep the
starting point fixed. In other words, the formula would be
=SUM(A$1:A12). Pull down for A13 etc.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not