Hi Everyone,

I'm very new to this, but am desparate for some help.

I am trying to count how many times two types of companies are used for each employee. Using this site I found a formula that worked for one type of company, but I couldn't add the second company I wanted it to look up:

=SUMPRODUCT(--('relocation capture'!$E:$E="Alvarez, Isabel"),--ISNUMBER(SEARCH("Award Escrow","Escrow Network",'relocation capture'!$I:$I)))

This is what I want:

Employee Company
John Award Escrow
John Escrow Network
John Peak Escrow

I have a separate tab that is the summary tab that just gives you totals for each employee. For this Employee the total escrow companies should equal 2.

Does anyone know how to help me? I'm assuming a lookup type formula would probably be easier so I don't have to customize each search by Agent, but I'm unfamiliar with them and thought i would start with this.

I thank you in advance for anyone who is able to help.

Sincerely,

D