Using SUMIF, COUNTIF and Similar “IF” Functions
Do you need totals, an average, or a count of cells in a range, but only under certain circumstances? Then one of the several statistical “IF” functions will be useful. They let you use a criterion, or several criteria, to include or ignore chosen cells. They are:COUNTIF, COUNTIFS count those cells in a range that…