You could insert another column to concatenate the information in the 2
criteria columns, and then apply the countif function to the new
column.

For example,
column H would have the formula
=B1&G1 (or =concatenate(B1,G1) if you like the long version)

your countif function would be
=countif(Support!$H:$H,"bl-565*")


--
gailann
------------------------------------------------------------------------
gailann's Profile: http://www.excelforum.com/member.php...o&userid=30798
View this thread: http://www.excelforum.com/showthread...hreadid=504931