📊

Statistical Functions

5 functions

Averages, standard deviations, correlations, and forecasting

AVERAGE

Calculates the mean of the provided numbers.

Averages values that satisfy one condition.

Averages values that meet all of the specified conditions.

COUNTIF counts cells that match a condition. Give it a range and a criterion (like '>100' or 'East') and it tells you how many cells pass the test.

Counts cells that meet all of the specified conditions.