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".
|