From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using SUM and AVERAGE

Using SUM and AVERAGE - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using SUM and AVERAGE

Two of the most widely used calculating tools we need in Excel are totaling and averaging and we've got functions for those. Reminder, it's "Sum" for totals, "Average" for averaging. In cell G3, we need a total here, but rather than using the Sum function, let's use something called the AutoSum tool. It's found two places in the ribbon. On the Home Tab, you'll find it way off to the right, right here in the Editing Group. It's also found, as you might expect, on the Formulas Tab in the ribbon. Here it's off to the left-hand side. In both cases there's a little drop arrow associated with it as well. There is also a keystroke shortcut, Alt+=. If we want a total in cell G3 of the adjacent cells to the left, we can click the AutoSum button and see what the AutoSum tool is about to do. It's about to add up the cells to our left. That looks good. We'll press Enter. The AutoSum button is designed to look at data both upward and to the left to tabulate totals. Now, we can do this slightly…

Contents