I want to SUM every numbers on column "AF" row by row like gradually. Adding their number to each other is like a ladder which is added up gradually line by line pointing upwards. And with multiple criterias based on colums "K" and "O" and doing this all by formula. Can we do this some stuffs like this ?

I was trying with my attemp and it seems failed it doesn't work at all. And please see my formula code down below here : =FILTER(IF($AF$3:$AF="";"";IF(IFERROR(MATCH($O$3:$O;$O:$O;0);0)=ROW($O$3:$O);SUMIF($O$3:$O;$O$3:$O;$AF$3:$AF) SUMIF($O$3:$O;$O$3:$O;$AE$3:$AE);""));$O$3:$O<>"0")

And I attached the picture to explain more and than so you'll be understand what I mean is. And with the "expect output" in it hope can make this question more be clearly. Thanks in advance!

CodePudding user response：

You can use a formula like this. I don't get if you need to check if K is "CHECKOUT", if you don't delete that conditional:

=byrow(AF3:AF;lambda(each;if(each="";"";sumifs(INDIRECT("AF"&row(each)&":AF");Indirect("O"&row(each)&":O");Indirect("O"&row(each));Indirect("K"&row(each)&":K");"CHECKOUT"))))

It's in AK in your spreadsheet!