the -- convert a TRUE/FALSE to 1/0 so SUMPRODUCT can then do the arithmetic.

an alternative is:

=SUMPRODUCT((MONTH('Raw Data'!A2:A14000)=6)*('Raw
Data'!:B14000="XIAPPLXRP110"))

HTH


"Teethless mama" wrote:

=SUMPRODUCT(--(MONTH('Raw Data'!A2:A14000)=6),--('Raw
Data'!B2:B14000="XIAPPLXRP110"))

you can not use whole columns (e.g A:A) unless you use XL2007


"Amber" wrote:

Good Morning,

I have a situation where I would like to count the number of orders created
by a certain person within a specific month.

What I would like to say is Count the number of orders that were placed in
the month of June for XIAPPLXRP110

Here is the formula I was trying to use which obviously did not work.
=IF('Raw Data'!a2:a14000(left,A2,2,=6/),COUNTIF('Raw
Data'!B:B,"XIAPPLXRP110"),"")

Here is some sample data below.
Date Creator Order #
6/5/2007 SCHMINKN 427998
7/24/2007 SCHMINKN 427954
6/27/2007 XIAPPLXRP110 428031
7/2/2007 XIAPPLXRP110 427985
6/18/2007 PATTEEA 427947
7/8/2007 PATTEEA 427944

HELP Please. I am trying to do these myself but I am struggling.