Jun 02 2022 02:39 AM
hi
I need help calculating the total number of attendees confirmed for an event to using a vlookup (unless there is any other formula I can use). data is as follows:
columns A and B have first names and surnames
column E has Y to confirm that they have confirmed attendance, and rows 6-97.
I typed the following
Jun 02 2022 02:47 AM
SolutionJun 02 2022 02:47 AM
Solution