software

Column B contains a formula result of either quot;DUPquot;, quot;NoDUPquot; or its blank quot;quot;.
Column M contains either quot;Yquot;, quot;Nquot; or it is blank (no formula in cloumn M). I
would like to calculate the number of time NoDup and Y appear in the same
row. Any thoughts?

Thanks for any help that can be offered.

Steve

one way=SUMPRODUCT(--(B1:B60=quot;NoDUPquot;),--(C1:C60=quot;Yquot;))

Can't use entire columns and the ranges need to be same size.
--
Greetings from New Zealand
Bill K

quot;Stevequot; gt; wrote in message
...
gt; Column B contains a formula result of either quot;DUPquot;, quot;NoDUPquot; or its blank
gt; quot;quot;.
gt; Column M contains either quot;Yquot;, quot;Nquot; or it is blank (no formula in cloumn M).
gt; I
gt; would like to calculate the number of time NoDup and Y appear in the same
gt; row. Any thoughts?
gt;
gt; Thanks for any help that can be offered.
gt;
gt; Steve