Save Time with Excel AutoSum

Save time with this handy Excel function! On this episode of One-Minute Wednesday, Amber Brito will be going over AutoSum functionality in Excel. This is a quick way to calculate the sum of a range of numbers in Excel.

How to Use AutoSum

To calculate the sum of a range of data in Excel, select the Formulas tab in Excel and then select the cell where you’d like your SUM function. From there, head over to the Function Library group and click the drop down arrow next to AutoSum. Select SUM, and a new formula will appear in your selected cell.

You can find AutoSum in the Formulas tab

From here you’ll want to specify the cell range that you want the SUM formula to calculate. You can either type in the range (B2:E2 in this case) or you can click and drag across the desired cell range. Once you have the appropriate cells selected, simply hit Enter on the formula bar and your total will appear.

Specify the cell range for your SUM formula

If you’d like to edit the function—when, for example, you add an extra column that you need to include in the formula—select the cell where the function is defined and then click on the formula bar. When you’re done editing the range, hit Enter again and your function will be updated.

Edit the function by selecting the cell and using the formula bar

And that’s it! You’re off to a great start with Excel functions. Take some time to poke around in the Function Library to see what else you can accomplish with these powerful tools.


More Posts

Cup of IT: Share Files Securely with Microsoft 365

Microsoft 365 offers valuable features and capabilities to ensure your files are protected and are only accessed by the right people. On this episode of Cup of IT, we’ll be discussing how to safely, smartly and easily share and receive files in Microsoft 365.

Cup of IT: Sending Secure Emails with Microsoft 365

Microsoft 365 comes with several built-in security features that allow your organization to manage how sensitive information is handled via email. On this episode of Cup of IT, we’ll be discussing how to send secure emails using sensitivity labels, email encryption, and the do-not-forward options in Microsoft 365.

Clean Your Inbox with Outlook Folders

Using Outlook folders is a great way to begin relieving the stress of managing your inbox. On today’s One-Minute Wednesday, you’ll learn how to create customizable folders that can automatically categorize your email, giving you a better experience with your inbox.

Blocking Senders in Microsoft Outlook

Tired of junk mail getting past your built-in spam filter? You can quickly and easily train your junk folder in Microsoft Outlook. On today’s One-Minute Wednesday, Sean Mountain will show you how to mark email as junk and block senders, giving you more power over what shows up in your inbox!