- Excel Book Excerpt
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?
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.
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.
For more resources for Microsoft Excel: