Try this:

=SUMPRODUCT(--(A1:A20="M&P),--(NOT(ISNUMBER(SEARCH("@",B1:B20)))))

Adjust the ranges to suit your data.

Hope this helps.

Pete

On Mar 17, 4:04*pm, whyrajesh wrote:
Hello all

column 1 * *column 2

M&P * * * * * xy.yahoo.com
others * * * *
M&P * * * * *
M&P * * * * * BLANK
others * * * *
M&P * * * * * mn.gmail.com

From the table above , I want to count M&P which doesnt contain @ in
Column 2

So here the answer should be 3.

Someone please help me with the formula !!!!

Thanks alot for the help

RYAN