Hi
I have a workbook (office 365) of class attendances with a summary sheet for the classes and also for the attendees.
Each of the class sheets contains a table with date and total (how many times they have attended that particular class) columns. Attendees can join multiple sessions and classes. I want to count how many classes (the number of session sheets) that each person features on. I was using this formula which worked =SUMPRODUCT(COUNTIF(INDIRECT("'"&Sheets&"'!"&"A9:A43"),B4)) but for some reason now doesn't.
I also then want to summarise how many sessions (across all classes) individuals have attended. I feel it should be easy but I'm really struggling so any help much appreciated.
I have a workbook (office 365) of class attendances with a summary sheet for the classes and also for the attendees.
Each of the class sheets contains a table with date and total (how many times they have attended that particular class) columns. Attendees can join multiple sessions and classes. I want to count how many classes (the number of session sheets) that each person features on. I was using this formula which worked =SUMPRODUCT(COUNTIF(INDIRECT("'"&Sheets&"'!"&"A9:A43"),B4)) but for some reason now doesn't.
I also then want to summarise how many sessions (across all classes) individuals have attended. I feel it should be easy but I'm really struggling so any help much appreciated.