There is no need for -- and *, they both do a similar job, and there is
absolutely no need to coerce the array of numbers

Either

=SUMPRODUCT(--(C1:C88=A7),--(C1:C88<=A7),--(I1:I88="Paint"),--(J1:J88="Inte
rnal"),K1:K88)

or

=SUMPRODUCT((C1:C88=A7)*(C1:C88<=A7)*(I1:I88="Pai nt")*(J1:J88="Internal"),K
1:K88)

is sufficient.

And doesn't

--(C1:C88=A7),--(C1:C88<=A7)

equate to

--(C1:C88=A7) ?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"VBA Noob" wrote in
message ...

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="I
nternal")*(--(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