| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i total up different pages all on one page?
I have 7 different pages that i am using for a daily contest. I would like
the last sheet to be a running total for all of the pages, how do i do these formulas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i total up different pages all on one page?
Hi,
If all the sheets are of the same format, then use =SUM(Firstsheet:Lastsheet!A2) Regards Govind. davey37736 wrote: I have 7 different pages that i am using for a daily contest. I would like the last sheet to be a running total for all of the pages, how do i do these formulas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i total up different pages all on one page?
I still cant seem to get it to work and i am not sure why........
"Govind" wrote: Hi, If all the sheets are of the same format, then use =SUM(Firstsheet:Lastsheet!A2) Regards Govind. davey37736 wrote: I have 7 different pages that i am using for a daily contest. I would like the last sheet to be a running total for all of the pages, how do i do these formulas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i total up different pages all on one page?
Davey: Your workbook must be set up "just so". See the complete instructions
of what Govind suggests he http://www.officearticles.com/excel/...rk sheets.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "davey37736" wrote in message ... I still cant seem to get it to work and i am not sure why........ "Govind" wrote: Hi, If all the sheets are of the same format, then use =SUM(Firstsheet:Lastsheet!A2) Regards Govind. davey37736 wrote: I have 7 different pages that i am using for a daily contest. I would like the last sheet to be a running total for all of the pages, how do i do these formulas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
| Page Numbers | Excel Discussion (Misc queries) | |||
| Varying page Excel report | Excel Discussion (Misc queries) | |||
| updated running total from previous pages | Excel Worksheet Functions | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Hybrid Mode
