Hello.
I have written up my work's budget including Income & Expenditure. Focusing on the Income side of things for this example I have listed all our sources underneath the title 'income'
eg.
INCOME
SOURCE
1. Affiliation
1.1 Club Affiliation £2.00
1.2 Other £1.00
Sub-Total
2. Grants
2.1 Company Grants
2.2 External Grants
2.3 Other
Sub-total
I know how to do the autosum so the grand total is calculated when numbers are entered
What I need help with is this:
- I want to include sub-totals but I don't know how to create them so that they don't count towards the overall total.
e.g. 1.1, 1.2 = £3.00 but at the moment the grand total would add all three figures up totaling £6.
How do i get it so the sub-total is calculated on its own when i enter figures into 1.1 and 1.2 and that the sub-totals are not counted towards the overall total?
Hope ive explained everything. Im using 2003 version.
Bookmarks