GROUP BY with COUNT, SUM & AVG: COUNTIFS, SUMIFS, AVERAGEIFS Tables
This lesson is part of the course
In this lesson
You build the result of GROUP BY region on Harbor & Pine Coffee's orders as a summary table with COUNTIF, SUMIF and AVERAGEIF, then a two-key GROUP BY region, category cross-table.
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
- SELECT & WHERE: Filter Rows with Flags and COUNTIFS Locked
- ORDER BY & LIMIT: Rank, Top 3 with LARGE and INDEX/MATCH Locked
- GROUP BY with COUNT, SUM & AVG: COUNTIFS, SUMIFS, AVERAGEIFS Tables Locked
- HAVING: Filter Groups on Their Aggregates Locked
- INNER JOIN: XLOOKUP and the #N/A Rows a Join Drops Locked
- LEFT JOIN & NULLs: IFNA, 'Unknown' and Unmatched Rows Locked
- DISTINCT & Duplicates: First-Occurrence COUNTIF Locked
- CASE WHEN & Date Functions: IFS Buckets and YEAR/MONTH Grouping Locked