Hi everybody, I'm new here and I'm from Croatia.
I have one question.
I do some statistics and I have rows like this: (with "" I'll mark blank cell)
A B C D E F G H I J K L
1 no x x "" x no x x "" x x x
2 x x x no x x x x x x x x
3 x no x x x "" x x x x no ""
So my question is: What formula is for count, in every row, just cells with "x" but only from last "no" in cell.
In this case result will be 5 for row 1, 8 for row 2 and 0 for row 3.
So this formula should automatically find last "no" in row and from that "no" count just "x's".
Thank you!
Bookmarks