VLOOKUP HELP REQUIRED

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