Hey guys,

I´m a newbie to excel and have a big problem. I have large tables that include different strings. For me only two are interesting: "win" and "run"

What I need: count all "run" per line (that´s easy). Sometimes there is a "win" without a "run" before. This is a mistake and so I have to count it as there was a "run" before.
So I neet a Function that counts the "win" per line ONLY if there is no "run" in the previous cell.

I wrote CELL("col")-1 because I tried to reach the cell before but (of course) this doesn´t work.

=ZÄHLENWENNS(Tabelle[[Spalte1]:[Spalte294]];"win";ZELLE("spalte")-1;NICHT("run"))

EN:
=COUNTIFS(Table([[Line1]:[Line294]]; "win"; CELL("col")-1; NOT("run"))

Is something like this even possible in a function?


Thanks for your help!