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

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

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

  1. Average the readings.

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

  2. The AutoSum dropdown offers additional functions.