Multi-Criteria Performance Report
Build a sales-rep scorecard for any date window with SUMIFS and COUNTIFS: won revenue, won deals, average deal size and a win rate that never errors.
What you will practise: Apply the same set of conditions (rep, stage and a date window) across SUMIFS and COUNTIFS, and build ratios from them that cope with a rep who has no deals.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.