ExcelBanter - I want to add formulas from multiple sheets to master form

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to add formulas from multiple sheets to master form (https://www.excelbanter.com/excel-worksheet-functions/261321-i-want-add-formulas-multiple-sheets-master-form.html)

snake941

I want to add formulas from multiple sheets to master form

How do I add formulas from multiple sheets in a workbook to a consolidated
worksheet?

Fred Smith[_4_]

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?

All times are GMT +1. The time now is 07:20 PM.