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 Show
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 function is used to add range of cells and then divide by the number of cell entries determining the mean value of all the values in the range?The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
Which function is used to add a range of cells?Sum a range of cells -- SUM Function
The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell. The SUM function totals one or more numbers in a range of cells.
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.
|