SOLVED

VLOOKUP HELP REQUIRED

New Contributor

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

2 Replies
best response confirmed by nessa1987 (New Contributor)
Solution

@nessa1987 

Does

 

=COUNTIF(E6:E97,"Y")

 

do what you want?

@Hans Vogelaar YES!!! Thank you so much!