Number List Sum
TextEverything runs locally in your browser — nothing is uploaded
Anyone holding a column of numbers almost immediately wants to know the average, how far apart the extremes are, and whether there is an outlier. Those all come from the same parse, so computing them costs nothing extra — and making you take the total elsewhere to find the mean would leave the job half done. Every common figure comes out at once, with the mode and quartiles on by default. Two ways to take numbers, for two very different inputs. Automatic extraction picks every number out of a block of text — logs, invoices, anything copied out of a spreadsheet with words and symbols in between. Splitting by a separator requires each item to be a number on its own, and records the ones that are not. One is lenient and one is strict; mixing them would make “why was this number left out” impossible to explain. What was skipped has to be said out loud. Quietly dropping a few items makes the total wrong while looking perfectly normal. So the number of skipped items appears as a row, with a few examples. When no number can be parsed at all, the tool raises an error rather than returning a table of zeros — 0 looks like an answer, whereas what actually happened is that the input contained no numbers, and the next step is completely different.
Features
- Count, total, mean, median, min, max, range, sample variance and sample standard deviation in one pass
- Plus mode and quartiles (Q1, Q3, interquartile range) — every tied mode is listed, and “no mode” is said plainly when no value repeats
- Two ways to take numbers: automatic extraction, or split by a separator
- Automatic mode understands thousands separators, decimals, scientific notation and signs
- How many items were skipped, and which ones, are both listed with a few examples
- Adjustable precision, with trailing zeros dropped, so 1 + 2 shows as 3 rather than 3.000000
- Skipped items count towards neither the total nor the item count
- Raises an error when there are no numbers at all instead of a table of zeros
- The result is an aligned table, and every row can be copied on its own
- Everything runs locally in your browser; nothing is uploaded
How to use
- Paste the numbers (one per line, or separated by commas or spaces)
- Choose split by a separator, or automatic extraction
- The result updates as you type; anything skipped is listed separately
- Copy a single row, or copy the whole table
FAQ
- Why is the total different from what I worked out myself?
- First look for a Skipped row. If it is there, some items could not be parsed as numbers — things like `12kg`, `N/A` or `50%` — and they were left out of the total; that row exists to tell you so. If you do want them counted, remove the units and symbols, or switch to automatic extraction, which will pull the 12 out of `12kg`.
- What does something like `3-5` count as?
- In automatic mode it becomes 3 and 5 — two items — because a minus sign immediately after a digit is read as a range separator rather than a sign. That is deliberate: in running text `3-5` is almost always a range, while ` -5` (after a space or at the start of a line) is read as minus five. For an exact reading, switch to splitting by a separator, where `-5` is always minus five.
- Is the standard deviation for a population or a sample?
- It is the sample standard deviation (dividing by n−1). The reason for that choice is that the input is nearly always a batch of observations — a day of takings, a run of part dimensions — and what you want to know is how much the thing behind them varies, which calls for the sample estimate of the population. With a single number the denominator would be zero, so that cell is left blank rather than filled with an invented 0.
Related tools
Fraction Calculator
ConvertSimplify fractions, find the greatest common divisor and least common multiple, convert decimals to fractions and do fraction arithmetic.
Number Base Converter
ConvertConvert numbers between binary, octal, decimal, hex, base 36 and base 64, with long IDs converted digit for digit. Runs in your browser.
Occurrence Counter
TextCount how often each character, word, line or given string appears, sorted by frequency with percentages. Spaces and breaks are labelled.
Text Diff
TextCompare two blocks of text online and highlight added, removed and unchanged lines, so only the lines that changed are marked. Runs in your browser.
Word Counter
TextCount Chinese characters and English words separately, alongside characters, lines, real UTF-8 bytes, reading and speaking time, and SMS segment counts.
Text Cleaner
TextClean up a column pasted out of a log or spreadsheet: deduplicate, sort, drop blank lines, trim whitespace and strip line numbers, all in your browser.