View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Copying a total from another Sheet

Bill

An easier method for your formula if A1 of each sheet is to be summed.

=SUM(Sheet2:Sheet15!A1)


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 07:01:09 -0800, "William Horton"
wrote:

You could also put on sheet 1 if you wish "=Sheet2A1 + Sheet3A1 + etc".