To count where col A="C" and Col B is not blank change

--($B$1:$B$6=1)

to

--($B$1:$B$6<"")


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=385674