Sum of continous cell

Sum of continous cell

Post by TWFu » Wed, 16 Jul 2008 01:00:06


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

Post by Sm9obiB » Wed, 16 Jul 2008 01:10:01

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

 
 
 

Sum of continous cell

Post by R2FyeSBCcm » Wed, 16 Jul 2008 01:14:00

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
 
 
 

Sum of continous cell

Post by T. Valk » Wed, 16 Jul 2008 01:45:20

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