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.
Related calculators
Flash Shooting Distance
HobbyCalculate the ideal shooting distance to your subject from a flash unit's guide number, aperture and ISO.
Open calculator →Flash Aperture Calculator
HobbyCalculate the correct f-stop for flash photography from guide number, distance, and ISO. Instantly see the nearest standard f-stop and the correct distance for each aperture.
Open calculator →Lens Focal Length Calculator
HobbyEstimate the lens focal length (mm) and 35mm equivalent you need from your subject distance, real size, and sensor width.
Open calculator →Camera Angle of View Calculator
HobbyEnter a lens focal length and image sensor size to instantly calculate how wide a scene the camera captures: the horizontal, vertical, and diagonal angle of view. Includes presets for full frame, APS-C, Micro Four Thirds and more (plus custom sensor sizes) and shows the 35mm equivalent focal length too.
Open calculator →