CELL ENTRY
A1 array formula that outputs {5,6,7}
A2 {5,6,7}
A3 ={5,6,7}
I have a formula in a cell, and I want to use A1 in that formula. I can't figure out how to do it.
For example, let's say the formula is ={sum({5,6,7})}. That gives 18. The formula ={sum(indirect(A2))} also gives 18. But I want to use the output in cell A1 in my formula. I can't get A1 or A3 to output 18 in the array sum formula.
Does anybody have any suggestions on how to do this?
A1 array formula that outputs {5,6,7}
A2 {5,6,7}
A3 ={5,6,7}
I have a formula in a cell, and I want to use A1 in that formula. I can't figure out how to do it.
For example, let's say the formula is ={sum({5,6,7})}. That gives 18. The formula ={sum(indirect(A2))} also gives 18. But I want to use the output in cell A1 in my formula. I can't get A1 or A3 to output 18 in the array sum formula.
Does anybody have any suggestions on how to do this?