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.

How to Sum Across Worksheets in Microsoft Excel. Using multiple sheets in the same Excel workbook helps organize data into distinct categories. For example, you might have sales data for each of ...

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.