SOLVED

VLOOKUP HELP REQUIRED

%3CLINGO-SUB%20id%3D%22lingo-sub-3459183%22%20slang%3D%22en-US%22%3EVLOOKUP%20HELP%20REQUIRED%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3459183%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20calculating%20the%20total%20number%20of%20attendees%20confirmed%20for%20an%20event%20to%20using%20a%20vlookup%20(unless%20there%20is%20any%20other%20formula%20I%20can%20use).%20data%20is%20as%20follows%3A%3C%2FP%3E%3CP%3Ecolumns%20A%20and%20B%20have%20first%20names%20and%20surnames%3C%2FP%3E%3CP%3Ecolumn%20E%20has%20Y%20to%20confirm%20that%20they%20have%20confirmed%20attendance%2C%20and%20rows%206-97.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20typed%20the%20following%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3459183%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3459272%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20HELP%20REQUIRED%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3459272%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1411254%22%20target%3D%22_blank%22%3E%40nessa1987%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIF(E6%3AE97%2C%22Y%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Edo%20what%20you%20want%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3459290%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20HELP%20REQUIRED%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3459290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BYES!!!%20Thank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
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!