Hi - I need to count the number of times a single or multiple set of columns contain "0" before the next column, which would contain a number. Probably not doing great describing it, but in the below example, I would want the formula to bring a result of 3:
<tbody>
</tbody>
So, I need to count the number of sets or number of single 0's within the range. In this case, there are 3 (in red). I also only need to count the sets of 0 after the first >0 cell in the range. So in the example above, I need to count the sets after the 3rd column or the cell with the # 12.
If i could avoid using an array that would be ideal, as I need to calculate this for 20K rows.
Thanks!
0 | 0 | 12 | 12 | 56 | 35 | 0 | 0 | 656 | 654 | 653 | 32 | 32 | 0 | 0 | 0 | 0 | 65 | 0 | 45 | 45 |
<tbody>
</tbody>
So, I need to count the number of sets or number of single 0's within the range. In this case, there are 3 (in red). I also only need to count the sets of 0 after the first >0 cell in the range. So in the example above, I need to count the sets after the 3rd column or the cell with the # 12.
If i could avoid using an array that would be ideal, as I need to calculate this for 20K rows.
Thanks!