Counting consecutive zeros at end of range

Hi, all. I'm embarrassed to be having this issue, but my brain simply isn't working this morning. I have the attached spreadsheet, which is going to be an attendance sheet for a group I'm in. The problem is in the Summary tab, column L. I want to figure out the number of consecutive times a person has missed coming to group events.

The wrench in this is that there are three types of events: one on Sunday, one on Tuesday, and other events that can happen any day of the week. I need to be able to count the Sunday and Tuesday ones separately, but also want an option for all three types to be considered together; hence the dropdown in O1.

For this exercise, the numbers are hard-coded into B2:G5, but they will be the results of formulas going forward. Also, my intention is that for each new event, a column will be inserted after G, so any formula will have to include an ability to grow with the sheet. Thanks for your help! I'm glad there are people on here much better than I am at this.