Formula in Excel

By Hodsocks
Apr 30, 2007
Topic Status:
Not open for further replies.
  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 Newcomer, in training Posts: 3,556

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

    TangoTrolly Newcomer, in training 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:
    http://www.homeandlearn.co.uk/ME/mes12p2.html
  4. Hodsocks

    Hodsocks TechSpot Guru Topic Starter Posts: 526

    Thanks you guys, job now sorted.
  5. TangoTrolly

    TangoTrolly Newcomer, in training Posts: 95

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


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.