View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth
 
Posts: n/a
Default Sum of cell on numerous worksheets in a workbook

=SUM('Sheet 1:Sheet12'!G13)

"Johnny D" wrote:

I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?