G
Guest
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.
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.