Home > other >  The subtraction from the number of each below of row on column AF. Get minus each others gradually r
The subtraction from the number of each below of row on column AF. Get minus each others gradually r

Time:11-23

=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"))))

the formulas by @Martin!

From the above of the formulas by @Martin I try to modify a litle bit to ajustment to my kinda of my case I thought by trying to change the "SUMIFS" into "MINIFS" will comes out as I expected but well it's not. It's not working at all even close as I imagine it before. I was wrong because it's not for a MINUS function but in other hand it's like for another function to get a MINIMUM of number in a dataset.

What I want is to get a SUBTRACTION every each row of them SUBTRACT from the number of every below of each of them with the two conditions : *first: based on the NAME on column "O". *second: based on the criteria I desired and should be a certain value like CHECKOUT on column "K".

And I attached the link 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!

enter image description here

  • Related