Did you enter the formula as an array formula <ctrl<shift<enter
instead of just <enter?

You could also try sumproduct, or countif nested with if statements


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=547943