I have been looking everywhere and can't find what I need.
For instance, I have these columns:
A B C D E F G
0 3 4 0 0 0 0
2 2 5 3 2 1 0
What I would like to count (backwards) is how many times does 0 show up. So, in the first row, it should give me 4 and in row 2 it should give me 1.
I want the formula to stop once it finds a different value than 0. I was thinking of a COUNTIF, but I don't know how to make it from right to left and to make it stop once it is different than 0.
Thanks in advance for your help.
Bookmarks