'Google Sheets ARRAYFORMULA to skip blank rows

How to make my ARRAYFORMULA(A1 + something else) to stop producing results after there are no more values in A1 column, eg. to skip blank values. By default it gives endlessly "something else".

Here is my demo sheet: https://docs.google.com/spreadsheets/d/1AikL5xRMB94BKwG34Z_tEEiI07aUAmlbNzxGZF2VeYs/edit?usp=sharing

Actual data in column A1 is regularly changing, rows are being added.

Solution 1:^[1]

use:

=ARRAYFORMULA(IF(A1:A="";;A1:A+1000))

Solution 2:^[2]

You can try this formula =ARRAYFORMULA(IF(ISBLANK(A1:A),"",(A1:A + B1:B))) if this works out for you.

Reference:

https://support.google.com/docs/answer/3093290?hl=en

Solution 3:^[3]

I tried the others and they didn't work. This does though:

=ARRAYFORMULA(filter(A1:B;A1:A<>"";B1:B<>""))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	player0
Solution 2	Diego Sanchez
Solution 3	Suraj Rao

'Google Sheets ARRAYFORMULA to skip blank rows

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]

Solution 3:^[3]