Spreadsheet formulas explained, side by side

Statistics & Counting Functions

Averages, medians, spread, ranks and percentiles. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
AVERAGEArithmetic mean of numbers or a range✔✔✔✔
MEDIANThe middle value of a set of numbers✔✔✘✔
MODEThe most frequently occurring number✔✔✘≈
MINThe smallest number in a list or range✔✔✔✔
MAXThe largest number in a list or range✔✔✔✔
COUNTCount how many cells contain numbers✔✔✔≈
COUNTACount non-empty cells (numbers, text, anything)✔✔✔≈
STDEVStandard deviation of a sample or a whole population✔✔≈≈
LARGEThe k-th largest value: 2nd highest, 3rd highest…✔✔✘≈
SMALLThe k-th smallest value: 2nd lowest, 3rd lowest…✔✔✘≈
RANKThe position of a number in a list (1st, 2nd, 3rd…)✔✔✘≈
PERCENTILEThe value below which a given percent of the data falls✔✔✘≈

✔ built-in function   ≈ works with a workaround formula   ✘ not available