Count Most Recent Consecutive Non-Zero Values

The basic idea is counting the number of days a value has been above zero and the results resetting if zero occurs, as seen below (results in bold):


4 9 0 6 2 7 3
1 0 0 4 0 7 1
- - 1 4 9 0 0
- 1 0 0 4 8 2

There will be new additions on a rolling basis so some columns will be empty. I've tried various formulas with a mix of FREQUENCY, COUNTIF, and COLUMN-MATCH formulas with no success. Any help would be appreciated, a sample excel book is attached.

Please try at T2
=COLUMNS(A2:S2)-MATCH(1,INDEX(0/(A2:S2=0),))

Hi Aging and welcome to the forum,

This takes an Array function where you need to do a Ctrl+Shift ENTER key combination to get the curly brackets around the formula. See the attached where I've done the correct formula in the Yellow fill cells.

It looks like this:

Formula:

Please Login or Register  to view this content.

Open the attached workbook below to see it work.
CSE Numbers after last zero.xlsx