Try this:

Where "yellow pages" could be in F1:F20 and "interested" could be in
H1:H20:

This formula counts instances where cells in Col_F equal "yellow pages"
and the corresponding cells in Col_H equal "interested":
A1: =SUMPRODUCT((F1:F20="yellow pages")*(H1:H20="interested"))

Are we there yet?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=516297