Aggregate and arithmetic operations

Capire Excel

Jess Ahmet

Content Developer, DataCamp

Functions in Excel

 

 

Function library

Capire 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
Capire Excel

Aggregate functions

University of DataCamp

Sample student test score dataset

Capire 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
Capire 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()
Capire Excel

Let's practice!

Capire Excel

Preparing Video For Download...