Forum Discussion
XL Formula Help (count cells with consecutive zeroes)
Hi there! Asking for a bit of help as I am stomped. Need a formula that helps me count "how many consecutive cells" to the "left" include zeroes (until a positive number is present)... COMPANY J...
If such variant is considered
it could be
=COLUMNS( B2:G2 ) - IFNA( LOOKUP( 2, 1/B2:G2, SEQUENCE(,COLUMNS( B2:G2 ) ) ), 0 )
Yes, that is better 🙂