Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
One of Excel's best calculation tools and used in lots of formulas is the AutoSum capability. It's on the Formulas tab in the Function Library here on the left side also on the Home tab, in the Editing group on the right side AutoSum. Has little drop arrow associated with it for other related functions as well. Let's use it in its most basic form. We are in cell G2 for example we want some totals. AutoSum is designed to quickly add totals from above or from the left.
It is context sensitive. The standard way to use this would be to put the active cell here and click AutoSum, and we view what's going on and if we are relatively new with functions and formulas in Excel we might look at that for a bit and also make figure it out and say oh yeah that looks good and what do we do next? Many people press Enter and that's fine. We could also press AutoSum a second time and of course that raises the idea this could be a little bit faster couldn't it? Next time we will need this in a situation why not double-click on Autosum? Makes it a bit faster. Another way to do this too by the way is a keystroke shortcut.
Now you might say well I am using the mouse to get here. Well maybe I have used the keystrokes so the keyboard to get here. Alt+Equal, and you have to press Enter there though to complete it. So here and there, that's going to be useful as well. We might want to use AutoSum here. Another approach to AutoSum is to highlight the data first. If it's highlighted in a column like this then we can either press Alt+Equal or AutoSum once, and the total goes below it. There you go, fast and easy.
Let me do that with Alt+Equal, highlight this data, Alt+Equal and then although no better, but sometimes we do this possibly by mistake, but by design if we highlight data this way and press Alt +Equal or the AutoSum button once, we get an answer there too. Be open to the idea that sometimes rather than putting AutoSum in once and then copying it, suppose we want totals on the right-hand side of the data here down in rows 12, 13 etc.
Right here highlight the data, click AutoSum once we got our totals. What if we wanted totals in the bottom? We could have highlighted these and press AutoSum once, or as I press Ctrl+Z twice to undo these. Why not take care of both sets of totals at the same time? Highlight the data this way to include the empty cells on the right in column H and the empty cells below this in row 16, then click AutoSum once. Works just fine. If instead of totals here, if we wanted averages, we would have highlighted the data here.
Click the drop arrow use Average, we get averages on the perimeter, and obviously we need to do some formatting there. The comma button would be a quick fix possibly. But it's easy to use AutoSum, and its related drop arrow capabilities, a good quick way to take care of lots of formulas in Excel.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64717 Viewers
80 Video lessons · 124327 Viewers
52 Video lessons · 60259 Viewers
59 Video lessons · 46095 Viewers