Sum of continous cell

  • Thread starter Thread starter Man
  • Start date Start date
M

Man

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.
 
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.
 
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
 
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)
 
Back
Top