Three-Variable Function Calculator (Combine 3 Columns)
Paste three columns of x, y and z, then apply operations like sum, product, average or x×y+z all at once. See per-row results, totals, averages and a bar chart together.
Input
Column x
(4 values)
Column y
(4 values)
Column z
(4 values)
Result
Operation x + y + z
Total of the result column
120
Average
30
Minimum
13
Maximum
47
Rows
4 rows
Result per row (bar chart)
Results table
| Row | x | y | z | Result |
|---|---|---|---|---|
| 1 | 10 | 2 | 1 | 13 |
| 2 | 20 | 3 | 1 | 24 |
| 3 | 30 | 4 | 2 | 36 |
| 4 | 40 | 5 | 2 | 47 |
| Sum | 120 | |||
| Average | 30 |
How it works
- Enter numbers into the x, y and z columns and pick an operation from the dropdown to compute the result for each row automatically.
- Supported operations are sum (x+y+z), product (x×y×z), average ((x+y+z)÷3), x×y+z, x+y×z, maximum and minimum.
- Input can be separated by line breaks, commas or spaces, and any token that cannot be read as a number is ignored.
- When the columns contain different numbers of values, the calculation uses the length of the shortest column.
- Results appear in a per-row table along with the total, average, maximum and minimum of the result column.
- The bar chart lets you visually compare the result of each row, with negative values shown in orange.
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 →