HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE

R

Randy

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.
 
L

~L

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).
 
Top