Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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.)

You can use the AutoSum Wizard to automatically build a Sum formula.  Select a range above/beneath or left/right of the range to be summed and goto the Formula tab on the Ribbon, then select AutoSum & SUM.

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 or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×