USER FORM ISSUES: Clear data from various ranges using checkboxes and other issues.

[MrBlackd]

This thing has gone further than I thought so I have one last question ...

I am attaching a sample of the excel file that I am working on so as to be better understood.

I have a weekly schedule for a guitar teacher that he has max 5 classes per day.
I want for every student to have a count of the times that the payment status is false or cancel

I have used named ranges for the cells that correspond to names and payment status and
tried with instr to search first for each student name and then offset 2 rows to check for
false or cancelled in the payment status but it was a fiasco so I am ahamed to share the code.

I appreciate any ideas.
thanks a priori