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

(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 *