Case 2: SUMIFS and COUNTIFS Report
This lesson is part of the course
In this lesson
Suggested time: 10 minutes. From 16 deals you build a region × category revenue grid, count big deals, total a date range and average one rep's deals.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Case 1: Lookups with XLOOKUP, INDEX/MATCH and Tier Tables Locked
- Case 2: SUMIFS and COUNTIFS Report Locked
- Case 3: IF, IFS, AND and OR Logic Locked
- Case 4: Percentages, Growth and the Classic Traps Locked
- Case 5: Text Cleanup and Concatenation Locked
- Case 6: Date Calculations with EOMONTH, NETWORKDAYS and DATEDIF Locked
- Case 7: Pivot-Style Summary with Formulas Locked
- Case 8: Final Mixed Assessment Locked