On a Excell spreadsheet how do I imput a formala in certain cells

[Bill Kaminska]

How do I imput a formala in a certain cell on my spreadsheet to total on the
last page. Each page has a total but I want to be able to total all those
totals from each page to a Grand Total on the last page?

 

[FSt1]

hi
if you just want to pull the value of one cell....
=sheetname!A1
or
=Sheet1!A1

you can put an equal sign in the cell you want the formula then click on the
sheet tab that has the data you want then click the cell that has the data
then hit enter. excel will write the fomula for you

regards
FSt1

 

[Peo Sjoblom]

=SUM(FirstSheet:LastSheet!A1)


replace first and last with your real first and last sheet names and A1 with
the total cell in those sheets


--


Regards,


Peo Sjoblom