Using Advanced Formulas

count, or average. A conditional formula is one in which the result is determined by the presence or absence of a particular condition. Conditional formulas used in Excel include the functions SUMIF, COUNTIF, and AVERAGEIF that check for one criterion, or their counterpoints SUM-IFS, COUNTIFS, and AVERAGEIFS that check for multiple criteria. ................
................