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: 3,556

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

    TangoTrolly TS Rookie Posts: 95

    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: 539

    Thanks you guys, job now sorted.
  5. TangoTrolly

    TangoTrolly TS Rookie Posts: 95

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

Similar Topics

Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...

Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.