how about this?

=COUNTA($c84:$d$99)-SUMPRODUCT((ISERROR(SEARCH(C65,$c$84:$d$99,1)))*1) +COUNTBLANK($C$84:$D$99)


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=382651