(Solved) – Count all 1 from A to G but stop if you reach 0 [closed]


Range from A1 to G1. Their values are either 1 or 0. I need help to count from A to G if the value is 1 and stop counting when the next value is 0.

What if the range is at a different sheet?

Leave a Reply

Your email address will not be published. Required fields are marked *