You may have used AutoSum to quickly add numbers in Excel. But did you know you can also use it to calculate other results, such as averages?
Use AutoSum to quickly find the average
AutoSum lets you find the average in a column or row of numbers where there are no blank cells.
-
Click a cell below the column or to the right of the row of the numbers for which you want to find the average.
-
On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.