Task 1 of 3
In E2:E4, count how many deals each manager has.
Lesson theory
=COUNTIF(range, criteria) counts the cells that meet a condition.
=SUMIF(range, criteria, sum_range) adds up only the matching rows.
The criteria can be a cell (D2) or text in quotation marks: ">800".
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.