David, I guess you are right.

Obviously I didn't read OP's question carefully enough...
---
Per Jessen

"David Biddulph" <groups [at] biddulph.org.uk skrev i meddelelsen
...
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