# Formula in Excel

By Hodsocks · 4 replies
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.

2. ### CCTTS EvangelistPosts: 2,610   +6

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

3. ### TangoTrollyTS RookiePosts: 56

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. ### HodsocksTS GuruTopic StarterPosts: 390

Thanks you guys, job now sorted.

5. ### TangoTrollyTS RookiePosts: 56

Thanks for posting the outcome.

Topic Status:
Not open for further replies.