Rolling count

[danielo08]

Hi all,

I'm trying to work out a customer's commitment using Excel, i have data where it gives a 1 if they've spent money with us during that year and 0 if they haven't.
Is there anyway to count each year if they've spent in consecutive years but reset the count to 0 if they stop for a year?

Attached an example. so in this example it'll count fiveyear+fouryear+threeyear but then reset because of the 0 in 2year and then count 2 for ly+cy.