I added the following constants
+---+---+---+
| | A | B |
+---+---+---+
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 2 |
+---+---+---+
Then on C1 I wrote the following formula
=A1:A3+B1:B3
The result was
Formula results in range value: A1:A3
On Google Sheets I could press Ctrl+Shift+Enter and it automatically puts the formula as argument of ArrayFormula function. On Excel it's required to first select the required area for the result, write the formula, and then press Ctrl+Shift+Enter.
Does ethercalc.org supports arrays formulas? How are they used?
References
- Using arrays in Google Sheets Google Docs Editors Help
- ARRAYFORMULA Google Docs Editors Help
- Guidelines and examples of array formulas Microsoft Support
- Non-Scalar Evaluation (aka 'Array expressions') Oasis Open Document Part 2: Recalculated Formula (OpenFormula) Format