AVERAGE |
Get the average of a group of numbers |
number1number2 … |

AVERAGEA |
Get the average of a group of numbers and text |
value1value2 … |

AVERAGEIF |
Get the average of numbers that meet criteria |
range criteriaaverage_range |

COUNT |
Count numbers |
value1value2 … |

COUNTA |
Count the number of non-blank cells |
value1value2 … |

COUNTBLANK |
excel-countblank-function |
range |

COUNTIF |
Count cells that match criteria |
range criteria |

COUNTIFS |
Count cells that match multiple criteria |
range1 criteria1range2 criteria2 … |

FREQUENCY |
Get the frequency of values in a data set |
data_array bins_array |

LARGE |
Get the nth largest value |
array n |

MEDIAN |
Get the median of a group of numbers |
number1numer2 … |

MIN |
Get the smallest value. |
array |

MODE |
Get the mode of a group of numbers |
number1number2 … |

RANK |
Rank a number against a range of numbers |
number arrayorder |

SMALL |
Get the nth smallest value |
array n |

STDEV |
Get the standard deviation in a sample |
number1number2 … |

STDEV.P |
Get standard deviation of population |
number1number2 … |

STDEV.S |
Get the standard deviation in a sample |
number1number2 … |

STDEVP |
Get standard deviation of population |
number1number2 … |