Your Excel formulas cheat sheet: 22 tips for calculations and common tasks. Max Productivity ... Use the AutoSum button to calculate basic formulas such as SUM, AVERAGE, COUNT, etc.

Averaging values in an Excel sheet is easy. But perhaps you want to ignore zeros or include multiple sheets. Knowing how each averaging function works is the key to choosing the right one.