Is it possible to put an array in a cell and then use that array in another formula by using the cell reference?
For example I'm putting an array in cell A1, so that A1 ={1;2;3;4}
Then in cell A2 I'm putting an array, so that A2 ={4;3;2;1}
If in cell B1 I put a formula ={1;2;3;4}+{4;3;2;1} I will get correct answer - {5;5;5;5}
But by putting in cell B2 a formula =A1+A2 I will get only one value - 5

Is it possible to somehow use cell references and get an answer as an array?