You are doing an AND test on the three values, not an OR. Use

=SUMPRODUCT(--(ISNUMBER(MATCH(Daily_CS_Tic_Dump!C1:C1000,{"Damag ed -
Non-Shipping Related","Damaged - Shipping Related","Defective"},0))))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"JR" wrote in message
...
Help please,

If I am wanting to count the number of times:

Damaged - Non-Shipping Related
Damaged - Shipping Related
Defective

appear in column C and return the numbers all together, why is hte
following
sumproduct returning a zero? These conditions are indeed located in the
column.

=SUMPRODUCT((Daily_CS_Tic_Dump!C1:C1000="Damaged - Non-Shipping
Related")*(Daily_CS_Tic_Dump!C1:C1000="Damaged - Shipping
Related")*(Daily_CS_Tic_Dump!C1:C1000="Defective") )

Thanks for the help.