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.

To learn more about Excel functions and formulas, read my past stories, including an Excel formula cheat sheet and a guide to the most popular Excel formulas. JD Sartain / IDG Worldwide.

Excel’s SUMIF() and COUNTIF() are two of my favorite summarizing functions and we’ve talked about both frequently in this blog. What we haven’t discussed is how to return a conditional average.