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.