If that is teh case, try this...
A B C D 1Sales 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
Bookmarks