COLLECT and ISBLANK

tfassnacht

Hello community,

I have a sheet called Boundary.

ColumnA is called "Distance" and has integers .

ColumnB is called "distance_to_increment" and has either an integer or a blank field.

 

From another sheet called Summry, I would like to sum, all distances which have a blank field for column B.

 

I struggle with the formula, for the "is blank" part.

 

SUM(COLLECT({Boundary:ColumnA},{Boundary:ColumnB},"")) does not work.

 

It seems "" does not refer to a blank field. How could I use ISBLANK() or something else ?

 

Thanks.

 

Paul Newcome

Replace "" with ISBLANK(@cell).