What is the formula for the SUM function in Excel?

What is the formula for the SUM function in Excel?

By /

The SUM function in Excel is a built-in mathematical function that allows users to add up a range of values in a selected range of cells. It is written as “=SUM(range)” and calculates the total sum of all the numbers included in the specified range. This function is commonly used in spreadsheets to quickly and accurately calculate the total of multiple values. It accepts both individual cell references and entire ranges of cells, making it a versatile tool for data analysis and reporting.

Excel SUM Function

SUM Function

The SUM function is a premade function in Excel, which adds numbers in a range.

It is typed =SUM

Note: The =SUM function adds cells in a range, both negative and positive.

How to use the =SUM function:

  1. Select a cell
  2. Type =SUM
  3. Double click the SUM command
  4. Select a range
  5. Hit enter

Let’s see some examples!

Great job! You have successfully calculated the sum of the stats using the =SUM function. The Pokemon’s stats have a total sum of 3092.

Let’s change one of the values in the range, to see what happens. Type D7(350):

Rattata total stats was changed from (D7)253 to (D7)350.

The SUM function updated the total sum from D12(3092) to D12(3189).

It updates the SUM when values inside of the range are changed.

Lets change Rattata stats to a negative number to see what happens. Type D7(-350):

The SUM is updated to D12(2489). Adding a negative number subtracts that value from the range.

The =SUM function adds both positive and negative numbers.

Cite this article

stats writer (2024). What is the formula for the SUM function in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/what-is-the-formula-for-the-sum-function-in-excel/

stats writer. "What is the formula for the SUM function in Excel?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/what-is-the-formula-for-the-sum-function-in-excel/.

stats writer. "What is the formula for the SUM function in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/what-is-the-formula-for-the-sum-function-in-excel/.

stats writer (2024) 'What is the formula for the SUM function in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/what-is-the-formula-for-the-sum-function-in-excel/.

[1] stats writer, "What is the formula for the SUM function in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. What is the formula for the SUM function in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. How can I use R to calculate the Sum of Squares Total (SST), Sum of Squares Regression (SSR), and Sum of Squares Error (SSE)?
  2. How can I use the SUM function in Excel to add up a range of cells and get the total sum?
  3. How to Sum Values Between Two Dates in Excel Using a Simple VBA Formula
  4. How can I use Excel to create a formula for calculating the sum of numbers if they are less than a specific value?
  5. How to Dynamically Sum Ranges in Excel Using INDIRECT and SUM
  6. How can I create a formula to calculate the sum by month in Google Sheets, using an example?
  7. What is the formula for calculating the sum of squares in ANOVA, and can you provide an example?
  8. How can I use the IFNA function in Excel to handle errors and display a specific value if a formula results in an error?
  9. How can I use the INDIRECT function in Excel to reference the contents of a cell and use it as a reference in a formula?
  10. How can I replicate the function- as an excel formula?
Slide Up
x
PDF
Scroll to Top