Conditional Aggregation

Learn how to write criteria and choose the right conditional aggregation pattern so you can count, total, average, and find extremes only for the rows that meet specific conditions.

Video Lesson Workbook

Below is the reference workbook from the tutorial. You can edit it on here or you can download it to work directly in Excel.