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...
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.