Task 1 of 6
In H2, count how many trips Sam made.
Lesson theory
A ride-hailing company is summing up the day. Practice COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF and MAXIFS.
Tip: a condition can be built from an operator and a cell, as in ">"&J1, and the wildcard "Comfort*" matches both "Comfort" and "Comfort+".
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.