+ Reply to Thread
Results 1 to 2 of 2

How to create sub-totals so they don't interfere with grand total

  1. #1
    Registered User
    Join Date
    08-13-2010
    Location
    cardiff
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to create sub-totals so they don't interfere with grand total

    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.
    Last edited by markypoos77; 08-13-2010 at 07:13 AM. Reason: got told off

  2. #2
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    Re: How to create sub-totals so they don't interfere with grand total

    Please attach a dummy workbook for users of the forum to look at. We will be able to better understand what's needed if you do so.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1