software

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=quot;Damaged - Non-Shipping
Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Damaged - Shipping
Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Defectivequot;) )

Thanks for the help.

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

=SUMPRODUCT(--(ISNUMBER(MATCH(Daily_CS_Tic_Dump!C1:C1000,{quot;Damag ed -
Non-Shipping Relatedquot;,quot;Damaged - Shipping Relatedquot;,quot;Defectivequot;},0))))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;JRquot; gt; wrote in message
...
gt; Help please,
gt;
gt; If I am wanting to count the number of times:
gt;
gt; Damaged - Non-Shipping Related
gt; Damaged - Shipping Related
gt; Defective
gt;
gt; appear in column C and return the numbers all together, why is hte
following
gt; sumproduct returning a zero? These conditions are indeed located in the
gt; column.
gt;
gt; =SUMPRODUCT((Daily_CS_Tic_Dump!C1:C1000=quot;Damaged - Non-Shipping
gt; Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Damaged - Shipping
gt; Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Defectivequot;) )
gt;
gt; Thanks for the help.
Try replacing the *'s with 's.

The way you've written the formula appears to be saying if,and,and rather
than if,or,or.

By using the instead of the * you're counting each criteria separately

Hope this helps

quot;JRquot; wrote:

gt; Help please,
gt;
gt; If I am wanting to count the number of times:
gt;
gt; Damaged - Non-Shipping Related
gt; Damaged - Shipping Related
gt; Defective
gt;
gt; appear in column C and return the numbers all together, why is hte following
gt; sumproduct returning a zero? These conditions are indeed located in the
gt; column.
gt;
gt; =SUMPRODUCT((Daily_CS_Tic_Dump!C1:C1000=quot;Damaged - Non-Shipping
gt; Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Damaged - Shipping
gt; Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Defectivequot;) )
gt;
gt; Thanks for the help.

You are multiplying which means you want all conditions to be true (and). I
bet you want to see if any of them are true (or) Try changing the * to .

--
Kevin Vaughnquot;JRquot; wrote:

gt; Help please,
gt;
gt; If I am wanting to count the number of times:
gt;
gt; Damaged - Non-Shipping Related
gt; Damaged - Shipping Related
gt; Defective
gt;
gt; appear in column C and return the numbers all together, why is hte following
gt; sumproduct returning a zero? These conditions are indeed located in the
gt; column.
gt;
gt; =SUMPRODUCT((Daily_CS_Tic_Dump!C1:C1000=quot;Damaged - Non-Shipping
gt; Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Damaged - Shipping
gt; Relatedquot;)*(Daily_CS_Tic_Dump!C1:C1000=quot;Defectivequot;) )
gt;
gt; Thanks for the help.