Additional Info

Share

  • Excel Book Excerpt

Excel Use the AutoSum Button to Enter Averages, Min, Max, and Count

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Use the AutoSum Button to Enter
Averages, Min, Max, and Count

Problem: I often enter totals formulas, but in this case, I need to enter an average formula. How can I do it quickly?

LE10000246.jpg 

Figure 270 Average the readings.

Strategy: You use the dropdown arrow located next to the AutoSum button. Instead of selecting Sum, you select the Average option.

LE10000247.jpg 

Figure 271 The AutoSum dropdown offers additional functions.

Additional Details: Excel does not remember the last setting of the AutoSum button. If you do an average and then use just the AutoSum button, it will return to using a SUM formula.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: