It sounds like you have criteria:

SheetB!A2:A897 = value in D
SheetB!B2:B897 = value in D
SheetB!B2:B897 = value in E (same as above?)

If that's the criteria, value in D must equal value in E in order to
count. Can you explain more?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=472703