Forum Discussion
Sum row until a blank cell is reached
Hello! What formula can I enter to sum a row of data until a blank cell is reached. I know the AutoSum function does this, but I am trying to create a template that has this formula entered for num...
Somewhat more verbose
=BYROW(
data,
LAMBDA(row,
LET(
accumulated, SCAN(0, row, LAMBDA(x, y, SUM(x, y))),
rowTotal, SUM(row),
XLOOKUP(TRUE, ISBLANK(row), accumulated, rowTotal)
)
)
)The formula returns a partial sum for each row of data.