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

G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for IF a total goes to 3 pages do not have on 2nd page 3
Formula for IF a cell contains value 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Atomatic subtotal in every pages. 1
automatic copy of results to another page 1
Group Totals and Grand Totals on each page 3
Fixing a Total on a page 9
Pivot Table Totals 1

Top