It is possible to make the Sum Excel formula reference another sheet, or multiple sheets, and add up a range of cells across those sheets.

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need. Clicking the "Insert Worksheet ...

You’ll learn how to: Navigate the Excel homepage Use rows, columns, and cells Enter and format data Create formulas like SUM Sort and organize your spreadsheet Work with multiple sheets in one ...

Add Multiple Projects in Excel Template Go to Projects Summary Sheet at the bottom of the workbook. Clear the existing sample projects in the second column from the column B range B4 to range B 13 ...

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.