I have strained my brain on this for a while, and i need help.
Similar to a countifs function, but the problem resides where i need to match certain words in a cell to another.
Attached is an example of what i am working on, it will make more sense when you see it.
I tried using an array formula, but i had no success.Count if.xlsxCount if.xlsx
Bookmarks