=SUM(Sheet1:Sheet30!D1:D10)

as an example

--
Regards,

Peo Sjoblom

(No private emails please)


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