Attendance Register

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!