I am stumped and need help. I want to create an excel sheet where I will input the results of each roll of the dice while I play online Craps, I want a formula that will show me how many rolls occur until a 7 comes up, not on which roll it pops up but how many rolls BEFORE it pops up. I can make it count until the first 7 but I need it to account for multiple 7's down the list as I input and cannot figure it out. Any ideas??