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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER