Aggregate and arithmetic operations

Understanding Excel

Jess Ahmet

Content Developer, DataCamp

Functions in Excel

 

 

Function library

Understanding Excel

Overview of aggregate functions

Aggregate functions: summarize a group of values into a single result

  • Commonly used aggregate functions include:
    • SUM
    • AVERAGE
    • COUNT
    • MIN
    • MAX
Understanding Excel

Aggregate functions

University of DataCamp

Sample student test score dataset

Understanding Excel

Aggregate functions: average

University of DataCamp  

Sample student test score dataset

 

Average: central or typical value in a set of numbers

  • Sum of all values divided by number of records
  • Formula
    • AVERAGE(B2:B11)
    • AVERAGE(B:B)
    • Notice the colon to indicate the range
Understanding Excel

Aggregate functions: continued

Min: minimum value in the column

  • MIN()

Max: maximum value in the column

  • MAX()

Count: number of records

  • COUNT()

Sum: total of all values in a column

  • SUM()
Understanding Excel

Let's practice!

Understanding Excel

Preparing Video For Download...