How to use the SUM Function and AUTOSUM in Microsoft Excel | Tutorial for Absolute Beginners
Posted on: 04/27/2021
contribution this :
Posted on : 04/27/2021 The SUM affair is the most popular and widely-used routine in Microsoft Excel, along with its automated interpretation : AutoSum. When you click AutoSum, Excel mechanically enters a convention ( that uses the SUM function ) to sum the numbers. In this video recording, I demonstrate the SUM function and read you a few tips that you may not know, even if you ‘ve used the SUM function for a while .
If you need to sum a column or row of numbers, let Excel do the mathematics for you with AutoSum. AutoSum is located on two tabs, the Home tab key and the Formulas tab key.
AutoSum in Excel
- 0:00 Intro
- 0:32 AutoSum
- 1:15 No numbers in the header
- 2:23 Select cells and AutoSum
- 3:15 CTRL to AutoSum ranges
- 5:20 Chart with AutoSum
When you click AutoSum, Excel mechanically enters a rule ( that uses the SUM function ) to sum the numbers. The SUM routine adds numbers .
SUM Function keyboard shortcut
The keyboard shortcut for AutoSum is ALT + =
SUM Function in Excel
Headers with Numbers
At 1:15 in the video, we look at how to apply AutoSum for a stove that has a issue in the header row. That might throw off the AutoSum function to add the header row value equally well. I show you how to circumvent that and exclude the header rowing from AutoSum by getting Excel to treat that cell as text .
If you have a header row in row 1, and cellular telephone B1 contains the year 2021, when you AutoSum or use the SUM function, it may include cell B1, which you did not intend. You should make B1 text rather of a value. To make B1 textbook, do one of the succeed :
- Type FY2021 in B1. FY is for Fiscal Year
- Type Year 2021 in B1
- Use the ‘ before 2021 to make it text. Example ‘2021
Number in the header row in Excel
Use CTRL to Sum multiple ranges and get a Grand Total in Excel
At 3:15 in the television, I demonstrate how you can create selections across multiple, non-adjacent number ranges and AutoSum everything mechanically. Excel is chic adequate to figure out that you have multiple ranges selected and AutoSum everything appropriately by taking into consideration the subtotals in your ranges .
Excel – CTRL to sum multiple ranges and get a grand total
Other Excel articles
share this :
Chris Menard is a Microsoft Certified Trainer and is employed full-time as a Trainer for a large national law firm with offices in 17 cities. Menard has a YouTube impart with early 750 engineering videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 10 million viewers have appreciated .