View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?