Attendance Register

  • Hi
    I have a spreadsheet with delegates attending a function whereby when I select Admit = Yes, excel must count the number of invitees for example 1 or 2 or 3 people and write that value in the highlighted cell in yellow and deduct from the number of people attending.
    And the same time highlight the row once the delegates have been signed in.
    I have tried countif and counta functions.


    I have attached my spreadsheet
    Any help is appreciated.