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.

An curved arrow pointing right. Analyze data across multiple worksheets with 3-D references. Produced by Sara Silverstein Follow BI Video: On Facebook More from Finance Analyze data across ...

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.