Skip to main content

Posts

Showing posts from December, 2018

New Article

How to SUM by matching partial text in Excel

How to use AutoSum in Excel

What is AutoSUM in Excel? AutoSum is a feature found in Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019. It helps user to calculate the SUM of multiple cells, multiple rows or multiple columns. It stays as AutoSum button (Drop Down List) under Editing group of Home tab. Image 1: AutoSum button in Microsoft Excel This feature made the SUM calculation quick and easy. Most of the beginner users use this AutoSum calculation feature in Excel for quick and easy way to calculate the SUM . The below example is for those users who wish to use AutoSum in Excel 2007, AutoSum in Excel 2010, AutoSum in Excel 2013, AutoSum in Excel 2016, AutoSum in 2016. This is also known as Quick Sum in Excel. You can apply the AutoSum feature for the following calculation: 1. AutoSum for Multiple Rows (with no blank cells) 2. AutoSum for Multiple Rows (with blank cells) 3. AutoSum for Multiple Columns (with no blank cells) 4. AutoSum for Multiple Columns (with blank ce