Ways to add values in a spreadsheet

One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed. (AutoSum can also work horizontally if you select an empty cell to the right of the cells to be summed.)

AutoSum creates the formula for you, so that you don't have to do the typing. However, if you prefer typing the formula yourself, see the SUM function. 

Add based on conditions

• Use the SUMIF function when you want to sum values with one condition. For example, when you need to add up the total sales of a certain product.

• Use the SUMIFS function when you want to sum values with more than one condition. For instance, you might want to add up the total sales of a certain product, within a certain sales region.

Add or subtract dates

For an overview of how to add or subtract dates, see Add or subtract dates. For more complex date calculations, see Date and time functions.

Add or subtract time

For an overview of how to add or subtract time, see Add or subtract time. For other time calculations, see Date and time functions.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.