课程: Excel Essential Training (Microsoft 365)

Using SUM and AVERAGE

课程: Excel Essential Training (Microsoft 365)

开始一个月试用

Using SUM and AVERAGE

“

- [Instructor] Because the SUM function is so widely used in Excel, there are two icons that you could consider using and also a keystroke shortcut. The AVERAGE function is also widely used, and although it doesn't really have a shortcut, there are some techniques that you might want to use as you work with that function as well. In this worksheet, we want to get a total in cell G2. Anytime you want to add up numbers from the left, you could take advantage of either the icon found on the Home tab, the far right. It's the Greek letter sigma. It's referred to as AutoSum, although we don't see that term there. Click this once, you see what Excel is about to do, you can press Enter. And after working with this for a bit, you'll realize it's practically foolproof. We can double-click that icon and it gets the job done. That feature is also designed to automatically look upward for numbers. So if I click on sell B8 and use that button or its identical companion found on the Formulas tab, the far left, AutoSum. Click it once, we see what's happening. Of course, we could double-click, but we'll click it again. We've got a total that way. Occasionally, you might have a situation like what we're seeing here in cell H6. We might want to be adding up those three numbers from the left. If we click the AutoSum button from either of its locations, Excel looks upward first. Now, we don't have to erase the bad guess, we'll simply highlight the other cells. Hold down that left mouse button and drag it across the cells that we do want to add up. Then we can press Enter. Now, in all these cases, we could have used Alt+=. I'm going to click on cell G2 and delete it. I'll press Alt+=, the shortcut for AutoSum, and Enter. So we could be using that at times as well too. We also have a list down below here of where we want a sum in multiple locations. We can highlight those ahead of time. And when we do, we need only click AutoSum once. Or if we prefer the keystroke shortcut. I've deleted these entries. I'll press Alt+=. We get the same totals. So both of those are reasonably fast. If we wanted totals on the bottom, we'd do the same thing. But what if we wanted totals on the bottom and on the right side? We could highlight the data this way. And then, if we click AutoSum from either of its locations, we'd get our answers on the right side and on the bottom. I'll double-click one of these on the right side, we see what's happening. And another one. Adding numbers from the left. And here, adding numbers from above. Each time I'm double-clicking. And in that lower right corner. So I double-click, we're adding numbers from the left. So that's quick and easy too. Now, I'm going to press undo to undo my last action. And then go back to that AutoSum button, click the little drop arrow, and choose Average. And now, what do we get? Averages in the same way that we got sums, but they're, of course, from the right side and from the bottom appropriately. The AVERAGE function can be used in situations. And what we're seeing here on the screen is similar to what you might have seen in a previous movie. We're adding up numbers from above, getting an average this way. And nothing wrong with that, but the AVERAGE function is clearer. And when you see the word, you know immediately what it means. But when you're typing the function, many times you'll type it all, nothing wrong with that, but when you see it in the list, you can double-click also. Double-click it, and we want to average these cells here. And Enter. So the AVERAGE function has a shortcut in that sense, and also the way we used it here. But more often than not, the SUM function, which is more widely used, has those great shortcuts, the AutoSum icons and the keystroke shortcut, Alt+=.

内容