Q:

# What is a cumulative sum in Excel?

A:

A cumulative sum is a total amount resulting from the addition of several values. In Microsoft Excel specifically, it is a value reached by adding the numbers in a group of columns or rows.

## Keep Learning

In order to use the cumulative sum function in Excel, first choose the cells to be included. If, for example, the desired sum is of the numbers in cells A1 through A5, highlight a blank cell and enter the formula =SUM(A1:A5). By using the sum function in this way, any subsequent changes made in the included cells also changes the sum to reflect the new total.

Sources:

## Related Questions

• A: You can use several techniques to subtract a percentage from a sum in Excel. The Houston Chronicle elaborates on a simple method that can be used in versio... Full Answer >
Filed Under:
• A: To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula... Full Answer >
Filed Under:
• A: To find duplicates in Excel, select the data that needs to be searched, click on Conditional Formatting from the Home tab, create a new rule, and then form... Full Answer >
Filed Under:
• A: To perform a linear regression in Microsoft Excel, input a set of values, for both the y-axis and the x-axis. A scatter plot will be produced, followed by ... Full Answer >
Filed Under: