Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 More...Less Show
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Here’s a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787. To create the formula:
Each argument can be a range, a number, or single cell references, all separated by commas.
Give it a tryIf you want to play around with our sample data, here’s some data to use. You can see how the SUM function works by copying the following table into a worksheet and pasting it into cell A1.
Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. Need more help?
SUM functionExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example:
SUM(number1,[number2],...)
This section will discuss some best practices for working with the SUM function. Much of this can be applied to working with other functions as well. The =1+2 or =A+B Method – While you can enter =1+2+3 or =A1+B1+C2 and get fully accurate results, these methods are error prone for several reasons:
Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community.
See AlsoLearn more about SUM The SUMIF function adds only the values that meet a single criteria The SUMIFS function adds only the values that meet multiple criteria The COUNTIF function counts only the values that meet a single criteria The COUNTIFS function counts only the values that meet multiple criteria Overview of formulas in Excel How to avoid broken formulas Find and correct errors in formulas Math & Trig functions Excel functions (alphabetical) Excel functions (by Category) Need more help?Which of the following functions adds cell values together and divides the result by the number of values quizlet?The AVERAGE function calculates an average by adding cell values together and dividing the total of the values by 4.
Which of the following functions adds all the values and divides the result by the number of values average count max min?The AVERAGE function calculates the average of numbers provided as arguments. To calculate the average, Excel sums all numeric values and divides by the count of numeric values.
Which of the following functions would you use to determine the number of values in a specified range?Use the COUNT function in a formula to count the number of numeric values in a range. In the above example, A2, A3, and A6 are the only cells that contains numeric values in the range, hence the output is 3.
Which of the following functions gives the same result as totaling a range of values and dividing the result by the number of values in the range?Explanation: The =AVERAGE() function calculates the sum of the values involved and divides them with the count of the values.
|