Excel can be a powerful tool for your business, but it can also be daunting with its many formulas, charts, and formatting. Here we’ll take a look at two simple but very useful Excel formulas, and how to make them work for you. Follow these tips to add up numbers or average them!
Adding Up Numbers
You have multiple columns or rows of numbers. You don’t want to have to add them all up on your calculator, and you don’t want to have to re-add them if the numbers change. The simplest solution? Use AutoSum!
To add up a row or column of numbers, highlight all of the cells you want to add up (either vertically down a column or horizontally in a row). Then click AutoSum on the Ribbon in the Editing group. This will quickly add the sum of your selected cells in a cell below or to the right of your selection.
If you want to type the SUM formula, click in any empty cell and type =SUM(CELL:CELL). CELL:CELL are the first and last cells in your range. Therefore, a finished formula would look like =SUM(A1:A12). Press Enter on your keyboard and your sum should appear!
The AVERAGE formula works the same as the SUM formula. To use it, select a range of numbers. Then click the down arrow next to AutoSum on the Ribbon. From the drop-down list, select Average.
If you want to type the AVERAGE formula, it works the same way as the SUM formula as well. In a blank cell, type =AVERAGE(CELL:CELL). Again, CELL:CELL are the first and last cells in the range you want to average. Then hit Enter on your keyboard and your average number will appear.
Now you can use two of the easiest, most common Excel formulas!