| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE
I'm wanting to setup a page to list expenses and have the total for the page
show up on another page that would just show the totals. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE
The syntax for referencing another page is: =Sheet2!A1
If the sheet name contains a space, it will need to be contained within ' ', so 'Sheet With Space in Name'!A1. This can be inserted into a formula in the following way: =SUM('Sheet With Space in Name'!A1:A200) So on your totals page you could have in A1: TOTAL HOURS: And in B1 the formula =sum(Hours!C2:C42) (If column C on the hours page contained hours data). "Randy" wrote: I'm wanting to setup a page to list expenses and have the total for the page show up on another page that would just show the totals. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Web Queries and how Excel sees the "selected box" on the web page | Excel Discussion (Misc queries) | |||
| Excel Page Setup | Excel Discussion (Misc queries) | |||
| How do I change the defaults for Page Setup in Excel? | Excel Discussion (Misc queries) | |||
| Problem with Page Numbering | Excel Discussion (Misc queries) | |||
| Excel Printing and Page Setup | Excel Discussion (Misc queries) | |||
Hybrid Mode
