View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default I want to add formulas from multiple sheets to master form

Maybe something like this:

=sum(sheet1:sheet5!a1)

Regards,
Fred

"snake941" wrote in message
...
How do I add formulas from multiple sheets in a workbook to a consolidated
worksheet?