List Sum Calculator
One per line, or separated by commas or spaces. Non-numeric lines are ignored.
- 3,339.74
- Sum
- 5
- Count
- 667.948
- Average
- 3,339.74
- Positive total
- 0
- Negative total
- 1,500
- Largest
- 67.25
- Smallest
The list sum calculator adds a column of numbers pasted from anywhere and separates the positive and negative totals. That split is the reason to use it over a calculator app: when reconciling a statement, knowing the credits and debits separately is usually more useful than the net figure alone.
How it works
Input is split on any run of whitespace, commas or semicolons, and anything that does not parse as a number is discarded. Pasting a spreadsheet column with a header row therefore works without editing.
- Sum, count and average of everything that parsed as a number.
- Positive and negative subtotals, so credits and debits are visible separately.
- Largest and smallest values, which is the quickest check for a misplaced decimal point.
The count is worth watching. If it is lower than the number of lines you pasted, something failed to parse, usually a currency symbol, a thousands separator or a value in brackets meaning negative.
Examples
A column of expenses
Numbers
1250.50 89.99 432 1500 67.25
Result
Sum 3,339.74 · Count 5 · Average 667.948 · Largest 1,500 · Smallest 67.25
Five lines, five parsed values. If the count had read 4, one line would have contained something the parser rejected.
Mixed credits and debits
Numbers
500, -120, 340, -85, -200
Result
Sum 435 · Positive total 840 · Negative total −405
The net figure of 435 hides the fact that 405 went out. The two subtotals are what make a reconciliation possible.
Frequently asked questions
Why is my count lower than the number of lines I pasted?
Something did not parse as a number. The usual culprits are currency symbols, thousands separators like 1,250 which reads as two numbers, and accounting-style negatives written as (120). Strip those before pasting, or check which line is missing by comparing counts.
Does it handle numbers with thousands separators?
Not as you would hope. 1,250 is read as two separate numbers, 1 and 250, because the comma is a separator. Remove thousands separators before pasting, or export without them.
Why show positive and negative totals separately?
Because the net sum hides the scale of what happened. A statement netting to zero could be no activity at all or a hundred thousand in and the same back out, and only the subtotals distinguish them.
Why not just use the average calculator for this?
The average calculator focuses on distribution, mean, median, mode and spread. This one focuses on totals, which is what you want when adding a column of figures rather than analysing them.