Hi,
I have a list of mutual fund names in column A. I have a sumproduct formula that sums up the market value all the Morgan Stanley funds for particular clients. But I want to make sure that if Morgan Stanley incorporates the word "Fidelity" (or some other fund name) into the title of their fund, that I don't double count the values. So I'm trying to get a formula that will test for any instance of "Morgan Stanley" and "Fidelity" that is contained within the same cell; but for the entire list of mutal funds.
Any help would be appreciated.
Thanks,
Phillycheese