Sum Calculator (Add a List of Numbers)
Paste a list or column of numbers to add them all up.
Your numbers
Your results
Sum Calculator (Add a List of Numbers) by TheCalcTools
How the Sum Calculator (Add a List of Numbers) works
Paste numbers from a spreadsheet, a bank statement or a receipt, one per line or separated by commas or spaces. Negative numbers and decimals work.
Do not include thousands separators (write 1500, not 1,500), because a comma is read as a separator between numbers.
The formula
Worked example
Using the default values shown in the calculator:
| Numbers to add | 120.50 89.99 45.25 310.00 15.75 |
|---|
- 120.50 + 89.99 + 45.25 + 310.00 + 15.75 = 581.49.
- Average of the 5 numbers = 116.30.
Result:
| Total | 581.4900 |
|---|---|
| Count | 5 |
| Average | 116.2980 |
| Sum of squares | 121,014.0751 |
| Smallest | 15.7500 |
| Largest | 310.0000 |
Frequently asked questions
Why is my total wrong when numbers have commas?
A comma separates numbers, so 1,500 is read as 1 and 500. Remove thousands separators first, or use spaces or new lines between numbers.
Can it add negative numbers?
Yes. Write them with a minus sign, for example -45.25.
Sources and further reading
Related calculators
More in Statistics & Probability · All calculators
This calculator gives estimates for information only. Check important results independently before you rely on them. See our disclaimer.