Google Sheets ARRAYFORMULA to skip blank rows

Question

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.

Would you be able to provide a sample sheet with sample data so that we can see what we are working on? — Century Tuna, Jan 05 '22 at 19:34

score 2 · Accepted Answer · answered Jan 05 '22 at 20:14

2

use:

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

answered Jan 05 '22 at 20:14

player0

124,011
12
67
124

score 2 · Answer 2 · edited Apr 25 '22 at 11:41

2

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

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

edited Apr 25 '22 at 11:41

Suraj Rao

29,388
11
94
103

answered Apr 25 '22 at 11:40

Antonio

21
2

score 1 · Answer 3 · answered Jan 05 '22 at 19:50

1

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

answered Jan 05 '22 at 19:50

Century Tuna

1,378
1
6
13

Google Sheets ARRAYFORMULA to skip blank rows

3 Answers3