Task 1 of 6
In G2:G4, calculate each rep's revenue.
Lesson theory
You have a log of deals over 3 months. Build a report for your manager: revenue and number of deals per rep, their share, the average deal size, and March sales.
A date condition takes two criteria: "from" and "to":
=SUMIFS(D2:D13,A2:A13,">="&DATE(2026,3,1),A2:A13,"<="&DATE(2026,3,31))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.