This allows you to see what a total was up to a particular point in time (for example, month-to-date, year-to-date, etc.). Sometimes we want a formula that progressively adds values up to the most recent value entered. This method can be useful for adding an entire column or row of values without scrolling to the first cell in the range. It automatically enters a SUM formula in the selected cell. The SUM function ignores text values, so a valid result is returned.ĪutoSum is a quick way to sum a range of cells. However, an error results if the plus sign is used when one cell includes a text value. It’s true that you’ll get the same results whether you use the plus sign or SUM in the following example.
Here is another advantage of the SUM function.
It’s far quicker to type “SUM” and highlight the range to be added than it is to type each value one by one. The first and most obvious reason is, of course, efficiency, especially in the case of a range of cells.
But you may wonder why we need a special function to do that when the plus sign works just fine. That’s neither surprising nor earth-shattering.
