In a sheet, I make calculations horizontally, however I can't build the arrayformula to expand calculation vertically on each row.
See the following sheet:
Select the tab "arrayformula", and point to the formula in column F
=COUNTA(B3:E3)
How can I apply arrayformula so it can expand to all the rows?
Best Answer