In your range you need to select one sheet at a time. You might have to
do a countif for each sheet and then add them all up.


--
BlueDaze


------------------------------------------------------------------------
BlueDaze's Profile: http://www.excelforum.com/member.php...o&userid=27465
View this thread: http://www.excelforum.com/showthread...hreadid=469781