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...
Just in case anyone is interested in a 365 beta release solution ...
= REDUCE(6,SEQUENCE(6),
LAMBDA(acc,p,
IF(INDEX(amount,,p)>0,6-p,acc)
)
)
...or for versions pre dynamic arrays (pda), like Excel 2016 and others before 365 that not yet had functions like sequence().
=COLUMNS(B:G)-IFERROR(MATCH(2,1/B2:G2),0)
