in cell a4 and copied down thru a11

=SUMPRODUCT((B4=$B$12:$C$12)*(B4<=$B$13:$C$13)*($ B$14:$C$14))


--
duane


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