Hello all,
Could someone help me with a formula to count how many cells until first cell bigger than zero.
The starting point of the count is in the middle of the table and i need to count from right to left.
I have tried formula to count using INDEX MATCH like COUNT(G8:INDEX(B8:G8,MATCH(TRUE,B8:G8>0,0)))
But the counting is performing looking from left to right and bringing the wrong value.
Thanks
Bookmarks