I need to create a spill formula for a running total
I’m able to create this formula using
=SUMIF($B$2:$D$2,"<="&COLUMN($B$2:$D$2)-1,B3:D3)
But I’m not able to understand how to make it work as one formula only so that I don’t have to drag for each row hoping someone can assist
>Solution :
We can use OFFSET and SUMIF:
=SUMIF(OFFSET(B3,SEQUENCE(ROWS(B3:D8),,0),0,1,SEQUENCE(,COLUMNS(B3:D8))),"<>")

