You can also create a running total (also called a cumulative sum) using an expanding range, which uses a combination of absolute (fixed) and relative cell references. A running total is especially useful if your data may change over time. For example, you can use a running total so you can see total sales change as you add sales for each month to your table. To learn more about absolute and relative cell references, see
This formula returns 160.
Add up a combination of individual numbers, cell values, and ranges: