IFs Function

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…