Wish Excel Had AutoAverage Like AutoSum?
August 13, 2014 - by Bill Jelen

It already does! Open the tiny dropdown arrow next to the AutoSum icon, and you have AutoAverage, AutoMax, AutoMin, and AutoCount!
This is one of the tips in Learn Excel 2007-2010 from MrExcel – 512 Excel Mysteries Solved.