There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions. Excel’s SUMIF() and COUNTIF() are two of my favorite summarizing functions and we’ve ...