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.

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.