Sum across Worksheets

[mortini]

Does anyone know of a way to easily sum a single cell across many
worksheets?
On an individual sheet you would do something like this
=Sum(A1:E1)

but how bout across worksheets
=Sum(Sheet1!A1:Sheet3!A1)
this does not work.

thanks for you help
rob

 

[Frank Kabel]

Hi Mortini
try
=SUM(Sheet1:Sheet3!A1:E1)

HTH
Frank