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

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?

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

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

"Bill Kaminska" wrote:

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?

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

=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


"Bill Kaminska" <Bill wrote in message
...
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?