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 ...

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.

Here are three methods to split Excel data into multiple sheets making your data easier to understand and boosting your productivity while ...