How to count the number of cells before a condition is met?

Hi guys,

I have a nice little problem that I cannot seem to get my head around. Say I have sales data of a product that doesn't sell every day. For instance, in Column A of the attachment, you will find some rows with a positive number but many rows with zeros. In the attachment, I let each row represent a separate date (with the same time interval per row).

I would like to add a column describing the number of rows it takes to get to the previous sales day with non-zero sales. But I have no clue which formula to use for it. I could use a progressive series of IF statements but this is ugly.
I have hardcoded the desired result in column B, labeled "intervals".

Any help is much appreciated!
Thanks,
Stuart

You indicated that you have dates attached to these?

Sorry FDibbins, I meant that one can consider each row to be a date. I have added this to the original post.

If that is teh case, try this...

	A	B	C	D
1		Sales	intervals
2	1/1/2016	0
3	1/1/2016	1	2	2
4	1/2/2016	0
5	1/2/2016	11	2	2
6	1/3/2016	0
7	1/3/2016	0
8	1/3/2016	0
9	1/3/2016	0
10	1/3/2016	2	5	5
11	1/4/2016	0
12	1/4/2016	6	2	2
13	1/5/2016	3	1	1
14	1/6/2016	0

(I used column D for comparison)...
D2=IF(B2=0,"",COUNTIFS($A$2:A2,A2))
copied down

This solution makes use of two helper columns*, D and E, with the respective formulas:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The formula in column C is:

Please Login or Register  to view this content.

*Helper columns can be hidden for aesthetic purposes.
Here is a copy of your file with the helper columns and formulas applied: Copy of example IFERROR(LARGE(INDEX(ADDRESS....xlsx
Let me know if you have any questions.