Totals and averages for any list of numbers
Sum and average a list of numbers without opening a spreadsheet. Paste a column of figures - prices, scores, durations, line items - and the tool returns a compact statistics block: count, sum, average, median, min, max, and range.
Each line is scanned for its first number, so "$1,200", "12 apples", and "-3.5" all parse to 1200, 12, and -3.5. Thousands commas are stripped and scientific notation ("1.2e3") is understood. Lines with no number at all are skipped, not counted as zero.
The median is the true middle value (the mean of the two middle values for an even count), so a single outlier does not distort it the way it does the average. Use the Decimals option to control how many places non-integer results are rounded to.
It all runs entirely in your browser as you type - your numbers are processed locally and nothing is uploaded.
How to use sum and average a list of numbers
- 1Paste your numbers into the input panel - one per line. Currency signs, thousands commas, and trailing units are fine.
- 2Read the statistics block in the output: Count, Sum, Average, Median, Min, Max, and Range.
- 3Adjust Decimals to round non-integer results (sum / average / median) to the precision you need.
- 4Copy the block, or hit Download to save it as a plain text file.
- 5Lines with no number are ignored - clean your list with Filter numbers first if you want to control exactly which lines count.
Keyboard shortcuts
Drive ListShift without touching the mouse.
What Sum & Average a List does
Seven figures from one paste - the spreadsheet round-trip a column of numbers usually needs, in a click.
Total a column of figures
Sum is the running total of every number found. Paste invoice line items, expense rows, or quantities and read the total off the top of the block - no `=SUM()` and no spreadsheet.
Average and median side by side
Average is the arithmetic mean; Median is the true middle value. Seeing both at once flags skew instantly - when the average sits well above the median, a few large outliers are pulling it up.
Min, max, and range
Min and Max are the smallest and largest values; Range is `max - min`. Handy for sanity-checking that every figure falls in an expected window before you import or report it.
Forgiving number parsing
Each line is stripped of thousands commas and scanned for its first number, so "$1,200", "12 apples", "-3.5", and "1.2e3" all read correctly. Lines with no number are skipped rather than counted as zero.
Runs live in the browser
The block recalculates as you type or paste. Nothing is uploaded - the math happens entirely in your browser.
Worked example
Six numbers in, a full statistics block out. Average and median round to the Decimals setting (2 here).
12 7 23 4 16 8
Count: 6 Sum: 70 Average: 11.67 Median: 10 Min: 4 Max: 23 Range: 19
Settings reference
One option plus the fixed parsing rules.
| Setting / rule | What it does | Example |
|---|---|---|
| Decimals | Rounds non-integer results (sum / average / median). Whole numbers show without trailing zeros. | "2" produces "11.67"; "0" produces "12" |
| Number parsing | First number on each line, after stripping commas | "$1,200" becomes 1200; "12 apples" becomes 12 |
| Lines with no number | Skipped - not counted as zero | "n/a" is ignored; Count excludes it |
| Median (even count) | Mean of the two middle values | middle of "4, 8" is `(4 + 8) / 2 = 6` |