Statistical Functions
Every function Excel offers for aggregating, counting, ranking, and analyzing numeric data. From the daily-driver AVERAGE and COUNTIF to serious analytics like STDEV and CORREL. Grouped by task, with deep guides for the ones you'll actually use — plus reference entries for everything else.
Featured guides — start here
The eight statistical functions we've written full guides for. If you're only going to learn a handful of stat functions, these are the ones that pay back the effort.
range, criteria pairs for AND logic. Scales cleanly.Basic aggregates
The everyday functions everyone learns first. Take a range of numbers, return a single summary value — no conditions, no filtering, just plain math.
1 Central tendency & extremes
The core "summarize a range" toolkit. Every Excel user knows AVERAGE; fewer reach for MEDIAN or MODE when they should.
Counting
Not "how big" but "how many". Five core functions distinguish numbers from text from blanks from conditional matches.
2 Cell counting functions
Match the function to what you're actually asking. "How many sales" = COUNTA. "How many valid numbers" = COUNT. "How many that match X" = COUNTIF.
Conditional aggregates
Averaging, counting, or finding extremes — but only for rows that meet conditions. This is where statistical Excel meets real business analysis.
3 Legacy — one condition
Excel 2003-era single-condition versions. Universal support, simpler syntax when you only need one filter. Note that SUMIF is in Math, not Statistical — a quirk of Excel's category system.
4 Modern — multiple conditions
The IFS family from Excel 2007+ (and MAXIFS/MINIFS from 2019+). AND logic across every criteria pair. Same argument order convention: aggregate_range FIRST, then range/criteria pairs.
Ranking & percentile
Where does a value stand relative to the rest? Rank it, find the nth largest, or compute percentiles for benchmarking.
5 Rank & order-statistics
RANK for "who's #1?", LARGE/SMALL for "who's the Nth?", PERCENTILE/QUARTILE for benchmarking against distributions.
Distribution & variance
How spread out is your data? How correlated are two columns? These are the analytics functions — real stats, not just aggregates.
6 Spread — variance & standard deviation
STDEV variants for standard deviation, VAR variants for variance. Choose .S for a sample, .P for a population — the distinction matters more than most people realize.
7 Relationships — correlation & regression
CORREL for "how related are these two columns?", SLOPE/INTERCEPT for fitting a line, LINEST for the full regression package.
8 Distributions & probability
Normal, binomial, Poisson, chi-squared — the classic textbook distributions. Use these when you need actual statistical inference, not just descriptive stats.
Which function should I use?
Match the task to the function
Common questions people ask about statistical work in Excel — and the right function to reach for.
COUNTIF(range, cell) > 1. Wrap in IF for readable labels or use it in a conditional-formatting rule.Related function categories
Statistical is one of Excel's function categories. If you're looking for something specific, it might live in a neighbor:
Templates that lean on statistics
These templates make heavy use of the statistical family — counting, aggregating, ranking, or benchmarking. Download any of them to see the functions in action.
Skip the syntax. Ask in plain English.
The Sheets & Cells AI Add-in writes COUNTIF, AVERAGEIFS, RANK, PERCENTILE, and every other statistical pattern — right inside Excel. Type "average sales by region excluding outliers" and get the working formula, ready to paste.
Try the AI Add-in →