How can I count the number of occurrences in another worksheet? In my spreadsheet, I have TAB 1, which features a list of courses + the total number of seats available. TAB 2 contains the registrations for each of the courses in TAB 1.
What I need to do is count the number of times a particular course appears on TAB 2 and return that information back to the “seats booked” column in TAB 1.
I’m looking for the total number of seats booked for each particular course. The data will come from TAB 2, but I need the answer to populate in TAB 1.
I can’t figure out what my formula should be… how to reference the other tab… where to enter that formula. Please let me know if I’m not being clear. Thanks!