Adding values in spreadsheets

  • Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.

A fast and simple way to adding values in spreadsheets is through AutoSum. Firstly, choose an empty cell right below a column of data. Then, select AutoSum > Sum on the Formula tab. As a result, Excel will now capture the range to be added. (AutoSum can even work along the same row if you pick an empty cell to the right of the cells to be summed.)

You can use the AutoSum Wizard for adding values in spreadsheets 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 builds the formula for you, saving you from having to type at all. However, if you prefer entering the formula manually, see the SUM function

Add based on conditions

  • Use the SUMIF function for any time you want to adding values in spreadsheets with one condition. For example, when you have to calculate the total sales of one product.
  • Use the SUMIFS function for when you want to sum values with several conditions. For instance, you may want to add up the total sales of a given product, within a certain sales region.

Add or subtract dates

For a summary of how to add or take away dates, see Add or subtract dates. For more complex date calculations, see Date and time functions.

Add or subtract time

For a summary of how to add or subtract time, see Add or subtract time. For different 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.

Please subscribe to my blog today to always get my latest posts and be in the know!

Subscribe Now!

Leave a Reply

%d bloggers like this: