Topics Map > OS and Desktop Applications > Applications > Productivity
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
- 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 - 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 Total
- 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).
- 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)
- After inserting the desired ranges hit
enter and the cell will fill with the function results.
SUM Function in Excel is a part of math function. It can be used as a worksheet function in Excel and this function is used to count the number of cells that contain numbers. If a cell is empty or not numeric, it will be ignored. This article will explain how to use sum function in excel.
If you know how to use sum function in excel, the excel SUM function can be used to quickly add up the values contained in a range of cells. It falls within the Math and Trigonometry category of functions, and its input consists of typing =SUM followed by the values that are to be added up at the end. The function can take in values in the form of numbers, cell references, or range references as its parameters.
How to use sum function in excel to sum range and sum entire column and row?
Sum Range:
1. After opening WPS spreadsheet select the cell where you want to sum the range.
2. Enter the formula in selected cell =SUM(B2:B9) in other way =sum(b2,b3,b4,b5,b6,b7,b8,b9) and press enter.
3. Once you press enter you will get the desired result means sum of chosen range in selected cell.
Sum entire Column or Row:
To sum a whole column, you can alternatively use Excel's SUM function.
1. After opening WPS spreadsheet select the cell where you want to sum the Column or Row.
2. Enter the formula in selected cell =SUM(B:B) in order to sum the entire Row =sum(5:5) and press enter.
3. Once you press enter you will get the desired result means sum of whole column or row in selected cell.
How to use sum function in excel to Sum Non-contiguous Cells?
To sum non-contiguous cells, you can use utilize Excel's SUM function. Non-contiguous refers to not being next to each other.
1. After opening WPS spreadsheet select the cell where you want to sum the contiguous cells.
2. Enter the formula in selected cell =SUM(b2,b4,b8).
3. Once you press enter you will get the desired result means sum of cell you have enter in formula.
How to use sum function in excel without using sum word in formula?
Sum cell without using sum word:
1. After opening WPS spreadsheet select the cell where you want to sum the numbers.
2. Enter the formula in selected cell =b2+b3+b4+b5.
3. Once you press enter you will get the desired result means sum of mentioned cells.
This article provides an explanation of the features that are associated with how to use Sum Function in Excel to get the correct and quick result. If, on the other hand, you are interested in learning more about the WPS office, I would like to direct your attention to the official website of the WPS Academy. The free version of WPS Office, which can be downloaded from this website, enables users to make changes to a variety of file types, including PDFs, Word spreadsheets, and PowerPoint presentations.