Aggregating by a single rule: department sales with SUMIF, staff headcount with COUNTIF, and benchmark averages with AVERAGEIF.
“9.2 Single-Condition Analysis: SUMIF, COUNTIF & AVERAGEIF” is part of Formulas That Do the Work. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
