Home > database >  Sum column until first empty cell
Sum column until first empty cell

Time:04-11

i have the following table:

A1 - 25

A2 - 26

A3 - 27

A4 - BLANK

A5 - 30

A6 - 23

A7 - BLANK

A8 - 24

In B1, i want the following - Starting from A1, sum up the entries until the first blank cell is encountered. In this case, it would be 25 26 27 = 78.

I have looked at multiple answers for hours and tried tweaking them, but nothing is working. Any help is appreciated (Also many things do not make sense, the function isblank(a1:a10) is going to return true or false, then how does arrayformula(isblank(a1:a10)) suddenly convert it to an array, since isblank is just returning a boolean?)

CodePudding user response:

Here's another way you can do it:

=sum(indirect("A1:A"&filter(row(A:A),A:A="")))

enter image description here

CodePudding user response:

Here's a couple of methods for it and a spreadsheet showing them both.

enter image description here

CodePudding user response:

try:

=FLATTEN(INDEX(QUERY(; "select "&SUBSTITUTE(JOIN(" "; 
 IF(INDIRECT("A1:A"&MAX(ROW(A1:A)*(A1:A<>"")))=""; 
 ","; A1:A)); " , "; ",")); 2))

enter image description here

  • Related