Hi Joe

I assume you mean you want the formula result to appear on sheet2. If
so, then just include the Sheet name plus an exclamation in your range
referencing.
=SUMPRODUCT(--(Sheet1!A2:A8="Nick"),--(MONTH(Sheet1!B2:B8)=6),--(Sheet1!C2:C8="PWP"))

--
Regards

Roger Govier


"Joe" wrote in message
oups.com...
OK, what do I need to do to the formula if I wanted to put the amount
of PWP errors Nick had for the month of June in sheet 2?

Thanks again for your help,
Joe

Joe wrote:
Thank you, both formulas work great! :-)


JMB wrote:
Try
=SUMPRODUCT(--(A2:A8="Nick"),--(MONTH(B2:B8)=6),--(C2:C8="PWP"))


"Joe" wrote:

I am looking for a formula that will help me capture all the PWP
error
codes Nick had for the month of June.

(A) (B) (C)
Name Date Error Code
Nick 06/20/06 PWP
Anna 06/21/06 PWP
Sal 05/25/06 PWP
Nick 06/20/06 IBU
Nick 05/22/06 PWP
Joe 06/23/06 PWP
Nick 06/17/06 PWP

The result of this example is 2

Any assistance is greatly appreciated.