# Aggregate Functions

- [AVERAGE](/cascade/functions-and-expressions/functions/aggregate/average.md): Averages a list of numbers
- [CORR](/cascade/functions-and-expressions/functions/aggregate/corr.md): Calculates a correlation coefficient
- [COUNT](/cascade/functions-and-expressions/functions/aggregate/count.md): Returns the count of all non-null values in a column
- [COUNTD](/cascade/functions-and-expressions/functions/aggregate/countd.md): Returns count of distinct values within a column
- [COUNTBY](/cascade/functions-and-expressions/functions/aggregate/countby.md): Counts the number of values within a column, partitioned by the unique values of a separate column
- [COUNTIF](/cascade/functions-and-expressions/functions/aggregate/countif.md): Counts values based on a condition
- [COUNTIFS](/cascade/functions-and-expressions/functions/aggregate/countifs.md): Counts values based on multiple conditions
- [COVAR](/cascade/functions-and-expressions/functions/aggregate/covar.md): Calculates covariance
- [COVARP](/cascade/functions-and-expressions/functions/aggregate/covarp.md): Calculates population covariance
- [COVARS](/cascade/functions-and-expressions/functions/aggregate/covars.md): Calculates sample covariance
- [MAX](/cascade/functions-and-expressions/functions/aggregate/max.md): Finds maximum value in a list of numbers
- [MEDIAN](/cascade/functions-and-expressions/functions/aggregate/median.md): Finds median value of a list of numbers
- [MIN](/cascade/functions-and-expressions/functions/aggregate/min.md): Finds minimum value in a list of numbers
- [MAXBY](/cascade/functions-and-expressions/functions/aggregate/maxby.md): Finds the maximum of a list of numbers, partitioned by the unique values of a separate column
- [MINBY](/cascade/functions-and-expressions/functions/aggregate/minby.md): Finds the minimum of a list of numbers, partitioned by the unique values of a separate column
- [PERCENTILE](/cascade/functions-and-expressions/functions/aggregate/percentile.md): Computes nth percentile of a list of numbers
- [STDEV](/cascade/functions-and-expressions/functions/aggregate/stdev.md): Returns the standard deviation of a list of numbers
- [STDEVP](/cascade/functions-and-expressions/functions/aggregate/stdevp.md): Returns the standard deviation of a list of numbers
- [STDEVS](/cascade/functions-and-expressions/functions/aggregate/stdevs.md): Returns the sample standard deviation of a list of numbers
- [SUM](/cascade/functions-and-expressions/functions/aggregate/sum.md): Sums a list of numbers
- [SUMBY](/cascade/functions-and-expressions/functions/aggregate/sumby.md): Sums a list of numbers, partitioned by the unique values of a separate column
- [SUMIF](/cascade/functions-and-expressions/functions/aggregate/sumif.md): Sums values within a column if specified criteria is met
- [VAR](/cascade/functions-and-expressions/functions/aggregate/var.md): Calculates variance
- [VARP](/cascade/functions-and-expressions/functions/aggregate/varp.md): Calculates a population variance
- [VARS](/cascade/functions-and-expressions/functions/aggregate/vars.md): Calculates a sample variance
- [RUNNINGTOTALBY](/cascade/functions-and-expressions/functions/aggregate/runningtotalby.md): Calculates a running total when grouped by a partition column
- [SIGN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sign.md): Determines the sign of a number
- [SIN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sin.md): Calculates the sine of an angle
- [SQRT](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sqrt.md): Takes the square root of a given number
- [SQUARE](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/square.md): Squares a given number
- [TAN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/tan.md): Calculates the tangent of an angle
- [ZN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/zn.md): Fill all null values with 0