Link to home
Start Free TrialLog in
Avatar of Dominator1025
Dominator1025

asked on

Need to deliver a count of certain names by looking for a string within a string and then counting the names associated with the smaller string

I have a file I have been working on. The formula in B3:E3 was successful in looking up 1 of the 4 objects in A3 and then returning a value associated with the object in a different tab.

Here, I have a new type of problem where I need a formula in B3 on my Formulas tab to look at column A on my Areas tab and count all of the cells that have "LA" or "Las Vegas" for the object names in A3 on the Formulas tab.  The answer should be 2.

Thank you!
Test-File.xlsx
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dominator1025
Dominator1025

ASKER

Awesome, thanks again!