What this category helps you do
Statistics formulas help turn raw data into summary numbers. They are useful for dashboards, survey analysis, quality checks, sales reports, performance tracking, and operational reviews.
- Count rows that match a rule
- Find average performance
- Rank top products or employees
- Measure variation in results
Statistics formula examples
Choose a formula below. Each page explains the formula in plain English and gives examples one at a time so long formulas are easier to read and copy.
AVERAGE
calculates the arithmetic mean of numbers.
Open examples →FormulaAVERAGEIF
averages values that meet one condition.
Open examples →FormulaAVERAGEIFS
averages values that meet multiple conditions.
Open examples →FormulaCOUNT
counts cells that contain numbers.
Open examples →FormulaCOUNTA
counts cells that are not empty.
Open examples →FormulaCOUNTBLANK
counts empty cells in a range.
Open examples →FormulaCOUNTIF
counts cells that meet one condition.
Open examples →FormulaCOUNTIFS
counts rows that meet multiple conditions.
Open examples →FormulaLARGE
returns the nth largest value.
Open examples →FormulaMAX
returns the largest number.
Open examples →FormulaMEDIAN
returns the middle value of a set of numbers.
Open examples →FormulaMIN
returns the smallest number.
Open examples →FormulaMODE
returns the most frequently occurring number.
Open examples →FormulaPERCENTILE
returns a value at a selected percentile.
Open examples →FormulaQUARTILE
returns a quartile value from a dataset.
Open examples →FormulaRANK
returns the rank of a number within a list.
Open examples →FormulaSMALL
returns the nth smallest value.
Open examples →FormulaSTDEV.S
estimates standard deviation for a sample.
Open examples →FormulaVAR.S
estimates variance for a sample.
Open examples →FormulaWeighted Average
calculates an average where each value has a weight.
Open examples →Best formulas to start with
How to learn this category
- Open one formula page and test the first beginner example.
- Change one cell reference at a time so you understand what each part controls.
- Check the common mistakes section before copying the formula down.
- Move to related formulas when you need a cleaner or more advanced version.