Microsoft Excel - Formula to Calculate Sum of Cells in Separate Worksheets

This document explains how to calculate the sum or total when working with cell data located in multiple worksheets. In other words, how to take the value of a cell located in one worksheet and add it to the value of another cell located in another worksheet to come up with the total of the respective cells.

Example using Sheet1 and Sheet2

  1. Sheet1 has the following table setup.

    Wisconsin Badgers Football

    Year Wins Losses
    2013 9 3
    2012 8 4
    2011 10 2
    2010 11 1
    2009 9 3
    2008 7 5

  2. Sheet2 has the following table setup.

    Wisconsin Badgers Football

    Year Wins Losses
    2017 9 3
    2006 11 1
    2005 9 3
    2004 10 2
    2003 7 5
    2002 7 6

    Wins Losses

  3. Click into the desired cell you wish to add contents and type =SUM( and then the cell range you wish to add. In our example we chose the cell range =SUM(C3:C8).

    Note: You are able to add multiple cell ranges by separating them by commas such as(B3:B8, C3:C8).

  4. To add a cell range from a different sheet, simply insert the sheet name with an ! at the end followed by the cell range. In our example we added a range from Sheet2 to Sheet1 with the following function: =SUM(B3:B8, Sheet1!B3:B8)

  5. After inserting the desired ranges hit enter and the cell will fill with the function results.

Keywords:excel formulas calculate values totals addition sums separate other different worksheets sheets   Doc ID:2100
Owner:Jeff W.Group:DoIT Help Desk
Created:2003-07-13 19:00 CDTUpdated:2015-06-09 10:11 CDT
Sites:DoIT Help Desk, Southern Illinois University Edwardsville
Feedback:  1803   1204