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.

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.

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.

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.