Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a formula that contains a complex embedded IF statement | Excel Worksheet Functions | |||
Is This Embedded in The COUNTIF() function??? | Excel Worksheet Functions | |||
Need help with an embedded IF statement | Excel Worksheet Functions | |||
list embedded in an if statement | Excel Discussion (Misc queries) | |||
reducing the number of times an IF statement needs to be calculated in embedded IF statements | Excel Discussion (Misc queries) |