Something like this??
=COUNTIF($I$1:$I$527,2001)&" and
"&COUNTIF(H:H,"5")-COUNTIF(H:H,"<0")
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=564611