Question: how to create a formula in excel for multiple sheets?
Answer: Once you have the name of the sheet you want to reference, here's how you change your Excel Sum formula so multiple sheets can be referenced at one time. Add the name of the sheet, followed by an exclamation point, and then the name of the cell you want to add: =SUM(Sheet1! A14,Sheet2! B17).