This question already has an answer here:
- Using SUMPRODUCT with ARRAYFORMULA 1 answer
This is my formula in cell
The values in column are all of the same length, and are continually updated by contributions from google forms. Therefore a condition based on length makes no sense.
How can I make an Arrayformula of this, so that the
F2's change with the row numbers? The function "indirect" isn't possible in an Arrayformula.