- 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.)
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
Add or subtract time
Need more help?
Please subscribe to my blog today to always get my latest posts and be in the know!