How to Add Values Across Multiple Sheets in Excel
This is a quick video on how to add data from different sheets in Microsoft Excel.
One option is to add the sheets individually in the formula such as:
=SUM(Sheet1!B1+Sheet2!B1+Sheet3!B1)
or you can add a range of sheets using:
=SUM(Sheet1:Sheet2!B1)