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.

--

John C

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

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

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)

--

Biff

Microsoft Excel MVP

=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

1. How to Sum-If when the cells to sum are Auto-filter visable cells?

2. cell a "bj" cell b "1.00, need to sum cell b1:b117 if a = "bj"

3. Help Please Sum Values in A Continous Form

4. Sum error on continous subform

6. Complicated continous form column Sum

7. show result of sum when summed cells are blank

8. strange sum question user inputs number of rows to sum in cell

9. Excel change SUM references if you cut & paste the first cell in SUM...

10. Excel change SUM references if you cut & paste the first cell in SUM...

11. Sum Function (was summing 13 cells to the left)

12. sum 2 values in diffnt cells with dup values, and sum if not dup

13. Formula needed for Sum(A1:C1) then Sum(D1:F1) in next cell

14. My Auto Sum Function is not Automaticlly summing the cells

15. Excel change SUM references if you cut & paste the first cell in SUM...

4 post • Page:**1** of **1**