That doesn't work I am afraid

=SUMPRODUCT(--(D2:D16="Red"),--(E2:E16=0),--(N2:N16<"dropped"),--(N2:N16<""))

--
__________________________________
HTH

Bob

"Roady" wrote in message
...
great- thanks!

So if in the last column, I do NOT want it to include 'dropped' or blank
cells- how do I indicate that? I tried doing the following but it is only
reading the 'dropped' and ignoring my request to eliminate the count if it
is
blank cell in N.

=SUMPRODUCT(--(D2:D16="Red"),--(E2:E16=0),--(N2:N16<{"dropped",""}))

Am I using the wrong symbols to indicate a blank cell? Or is it impossible
to do more than one 'does not include' (<)contingency?
Thanks again!