CODEWITHSUNDEEP
excelfunctioncountms-officevlookup
tacodestroyer
tacodestroyer

Reputation: 19

Display Count in cell with Excel & VLOOKUP w/Contains for certain letters

Phew, that was a lot to write as a title.

I'm looking to display a count within a cell, the count would source from a search of another sheet & column utilizing (I assume) VLOOKUP.

Example:

So, I want to look for all values in Sheet2/Column A that contain "SMITH"

Then, in Sheet1/A1, a count of all those values of "SMITH" would show up (let's just say 122)

So, I have 122 Smiths' in sheet2/ColumnA and the number, 122 (count) shows up in Sheet1/A1

I hope that makes sense. I'm pretty green (obviously) to Excel.

Thanks!

Upvotes: 0

Views: 54

Answers (1)

Aspiring Developer
Aspiring Developer

Reputation: 680

I believe you're looking for something like this:

=COUNTIF(A:A,"*"&"Smith"&"*")

With column A being where the names are.

Upvotes: 1

Related Questions