not sure I understand what you want to do but

=sumproduct((Data!$C$2:$C$191=Summary!B$3)*(Data!$ M$ 2:$M$191="X"))

i think will do it - count x's in column M subject to meeting critiera
for column C


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=496437