CountIf embedded in an IF statement
=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.
|