=SUM(Sheet1:Sheet2!A2)

will sum cell A2 on sheets 1 through 2.

--
HTH

Bob Phillips

"JRM" wrote in message
...
I want the sum of a cell from a range of worksheets. What is the formula?