Sorry, typo, the formula s/b as follows, to reference the range on sheet
1

=DCOUNT(Sheet1!$A$1:$B$9,2,D3:D4)


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512842