Take the example of a budget with 4 Quarters: in each of the 4 quarters we have the totals for each Month from January to December (i.e Jan, Feb, Mar for Q1, April, May, June for Q2, July, August, September for Q3 and October November & December for Q4).
In Q1 we would like to sum the totals for each month and also the summaries in the annual summary (see excel file)
The first step is to give a custom name to Cells B2:B6. You can do this by:
- Press CTRL + F3, then click new name or type the name in the name box or Click on the formulas tab, define name (Give the name "Expenses_January" - Note No spaces
- Select cell B7
- Type: =SUM(Expenses_January)
- Press Enter
0 comments:
Post a Comment