Hi,

Perhaps I've misunderstood but maybe this

=SUMPRODUCT((L2:L33331=B7)*(L2:L33331<=B9)*(LEFT( D2:D33331,9)="EQUIPMENT")*(LEFT(P2:P33331,8)="COMP LETE"))

Mike

On Thu, 22 Jan 2009 12:25:56 -0800 (PST), wrote:

Hi Group,
I am having trouble with a sumproduct formula.
=SUMPRODUCT(--(L2:L33331=B7),--(L2:L33331<=B9),--
(D2:D33331="EQUIPMENT")*OR
(P2:P33331="COMPLETE1",P2:P33331="COMPLETE2",P2:P 33331="COMPLETE3",P2:P33331="COMPLETE4"))
B7 and B9 are my inclusive dates, checked against Col L, and I want to
count the number of "EQUIPMENT" that are any of the 4 "COMPLETES".
This works very well if I only have 1 type of "EQUIPMENT", but even
then I'm not certain if that's the correct way to do that. My problem
arises when I want more than 1 "EQUIPMENT" , such as
"EQUIPMENT1","EQUIPMENT2","EQUIPMENT3","EQUIPMENT 4". Is there a way to
do what I'm asking? Any help will be very much appreciated!
Ken