Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |