Workbooks, not worksheets?
--
David Biddulph

"Per Jessen" wrote in message
...
Hi Neil

=SUM(Sheet1:Sheet100!A1)

Best regards,
Per

"Neil Pearce" skrev i meddelelsen
...
Dear all,

Is there a quick formula I can use to add all A1 cells across 100
different
workbooks?


Kind regards,

Neil