Formula in Excel

By Hodsocks
Apr 30, 2007
  1. I am sure this is simply enough to do but I'm just not up to speed with excel, I am producing a simple series of spreadsheets for someone to use as a register of people attending class. So far I have 12 sheets, one per month, and on each I have the list of names and the dates they have attended. At the end of the spreadsheet I have a total for the month and also a year to date total.
    What I want to know is how to I transfer the year to date total to the next spreadsheet so that by the end of the year they have the toatal for the year.
    Many thanks in advance.
  2. CCT

    CCT TS Evangelist Posts: 2,653   +6

    A1 (January), A2 (Feb), etc - A13 (total) = A1+A2+ etc
  3. TangoTrolly

    TangoTrolly TS Rookie Posts: 59

    To reference data on a different Sheet, use the 'Sheet' function. For instance if you want to add contents of A1 on Sheet1 to contents of A1 on Sheet2, use this formula: =Sheet1!A1 + Sheet2!A1

    Following URL has the full explanation:
  4. Hodsocks

    Hodsocks TS Guru Topic Starter Posts: 370

    Thanks you guys, job now sorted.
  5. TangoTrolly

    TangoTrolly TS Rookie Posts: 59

    Thanks for posting the outcome.
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...