Thing something like this might work.

You might need to enter 01-Jul-06 in A& and format cell as mmm-yy

=SUMPRODUCT(--(C1:C88=A7)*(--(C1:C88<=A7)*(--(I1:I88="Paint")*(--(J1:J88="Internal")*(--(K1:K88))))))

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566419