Hi all, I'm new here, please forgive me if I'm posting this wrong or in the wrong area. I've been struggling with this a bit. I'm trying to sum the most recent consecutive months until a 0 is reached. Please see my have/want below. HAVE: Month N Count SUM 1 0 2 1 3 1 4 0 5 1 6 0 7 1 8 1 9 1 WANT; Month N Count SUM 1 0 0 2 1 1 3 1 2 4 0 0 5 1 1 6 0 0 7 1 1 8 1 2 9 1 3 Thanks in advance!
... View more
