Mean, Median & Mode Calculator Plus range, sum, count, minimum and maximum — with the Excel formulas

Paste or type your numbers below. You'll get the mean (average), median and mode instantly, along with the full set of summary statistics. Separate values with commas, spaces or new lines.

Tip: you can paste a whole column copied straight from Excel or Google Sheets.

Mean (average)
sum ÷ count
Median
the middle value
Mode
most frequent
Count
Sum
Minimum
Maximum
Range

Do this in Excel or Google Sheets

If your numbers are in cells A1:A10, these formulas give the same results:

StatisticFormula
Mean=AVERAGE(A1:A10)
Median=MEDIAN(A1:A10)
Mode (single)=MODE.SNGL(A1:A10)
Mode (all, multimodal)=MODE.MULT(A1:A10)
Count=COUNT(A1:A10)
Range=MAX(A1:A10)-MIN(A1:A10)

Want to go from single formulas to building real dashboards and analysis? That's exactly what my Excel course covers, step by step.

Learn Excel with my course →

Mean, median and mode — what's the difference?

All three describe the "centre" of a set of numbers, but in different ways. The mean is the average: add every value and divide by how many there are. The median is the middle value once the numbers are sorted — half fall below it and half above. The mode is simply the value that appears most often; a set can have one mode, several, or none at all.

When to use each

Worked example

For the set 4, 8, 15, 16, 23, 42: the sum is 108 and the count is 6, so the mean is 18. Sorted, the two middle values are 15 and 16, so the median is 15.5. No value repeats, so there is no mode.

Frequently asked questions

Can a set of numbers have more than one mode?

Yes. If two or more values are tied for the highest frequency, the set is multimodal and this calculator lists all of them. If every value appears the same number of times, there is no mode.

What's the difference between mean and average?

In everyday use they're the same thing — "average" almost always means the arithmetic mean, which is what this calculator shows.

Does the calculator handle decimals and negative numbers?

Yes, both. You can mix whole numbers, decimals and negatives freely, separated by commas, spaces or new lines.

Is my data sent anywhere?

No. Everything runs in your browser — nothing you paste leaves your device.