blog home

GP5 - Aggregate functions (COUNT, SUM, AVERAGE, MAX, MIN, COUNTIF, SUMIF, AVERAGEIF) in Microsoft Excel

Subject: Business, Information Systems
Courses: K201
Posted by: Dalia

Today we're releasing a double feature on GP5. In this video, we start by explaining COUNT, SUM, AVERAGE, MAX, MIN. These concepts, also called aggregate functions, are pretty easy to understand. We'll then move on to COUNTIF, SUMIF, and AVERAGEIF, which are slightly more difficult but will definitely make an appearance in GP5.

Download the exercise files