Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of continous cell
I need to sum budget from month 1 to month "N", where "N" is a variable that
changes each month, but I don't want to change the sum formula, only the variable that represents the month. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of continous cell
Assuming your variable that changes each month is in cell B1, and assuming
the budgets from month to month are variable named such as Month1, you could use: =SUM(INDIRECT("Month1"):INDIRECT("Month"&B1)) Hope that helps. -- John C "Man" wrote: I need to sum budget from month 1 to month "N", where "N" is a variable that changes each month, but I don't want to change the sum formula, only the variable that represents the month. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of continous cell
Assume:
Col A has your budget categories such as Travel, Entertainment, etc Cols B thru M are 'Jan' thru 'Dec' - The months, 'Jan' thru 'Dec' labels are in row 2 Col N has formula for totals for 'Jan' thru 'Dec' - The data starts in row 3 Cell A1 has the 'current' month that you want to sum to. ie: In Jan, Cell A1 = 1, in Feb, Cell A1 = 2, etc The formula in cell N3 would be... =SUM(B3:OFFSET(B3,0,$A$1-1)) Copy this formula down the worksheet. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "Man" wrote: I need to sum budget from month 1 to month "N", where "N" is a variable that changes each month, but I don't want to change the sum formula, only the variable that represents the month. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of continous cell
One way:
=SUM(A1:INDEX(A1:L1,n)) Where n = your variable. N can be a cell reference or it can be calculated: A2 = 7 =SUM(A1:INDEX(A1:L1,A1)) =SUM(A1:INDEX(A1:L1,MONTH(NOW()))) Both of the above formulas translate to: =SUM(A1:G1) -- Biff Microsoft Excel MVP "Man" wrote in message ... I need to sum budget from month 1 to month "N", where "N" is a variable that changes each month, but I don't want to change the sum formula, only the variable that represents the month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic template with continous numbers changing only | Excel Worksheet Functions | |||
Print row labels that are continous | Excel Discussion (Misc queries) | |||
Continous updating of linked spreadsheet | Links and Linking in Excel | |||
Overwrite tab 1 (1 save per overwite), continous update in tab 2. | Excel Discussion (Misc queries) | |||
countif with non-continous ranges | Excel Worksheet Functions |