Thread: Summing Across Workbooks
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
  
Posts: 1,533
Default Summing Across Workbooks
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

Reply With QuoteReply With Quote