Two-Column Calculator (Add, Subtract, Multiply, Divide)
Paste numbers into Column A and Column B and run row-by-row addition, subtraction, multiplication, or division all at once. See the result column plus the total and average of each column, computed automatically.
Input
Operation (computes A □ B for each row)
Enter the same number of values in Column A and Column B. Newline, comma, and space separators are supported, and non-numeric entries are ignored.
Result
Sum of the result column (A + B)
1,155
Average 231 (across 5 rows)
Column A total
655
Column B total
500
Result column (A + B) total
1,155
Column A average
131
Column B average
100
Result column (A + B) average
231
Per-row results
| Row | Column A | Column B | A + B |
|---|---|---|---|
| 1 | 120 | 100 | 220 |
| 2 | 80 | 50 | 130 |
| 3 | 200 | 150 | 350 |
| 4 | 95 | 80 | 175 |
| 5 | 160 | 120 | 280 |
| Total | 655 | 500 | 1,155 |
| Average | 131 | 100 | 231 |
How it works
- Enter the same number of values in Column A and Column B, choose an operation (A+B, A−B, A×B, or A÷B), and view the calculated result for every row in a table. Input can be separated by newlines, commas, or spaces.
- The total and average of the result column are shown prominently, and the total and average of Column A, Column B, and the result column are displayed side by side. Handy for pre-calculations and checks before pasting into a spreadsheet.
- Averages are simple arithmetic means: each column's total divided by the number of values. In division (A÷B), rows where Column B is 0 cannot be computed, so they show "—" and are excluded from the result column's total and average.
- Calculation is not possible when Column A and Column B contain different numbers of values. Make sure the count of numbers separated by newlines or commas matches in both columns. Characters that cannot be read as numbers are ignored.
- All input is processed entirely in your browser and never sent to a server. Useful whenever you want to process two columns of data together, such as revenue and cost, test-score differences, or unit price times quantity.
Reviews
Tell us what you think of this calculator.
Write a review
Found an incorrect result or a problem? Turn this on to report it.
- Home
Two-Column Calculator (Add, Subtract, Multiply, Divide)