LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 68
Default CountIf embedded in an IF statement

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a formula that contains a complex embedded IF statement Tom Excel Worksheet Functions 1 May 18th 07 06:38 PM
Is This Embedded in The COUNTIF() function??? dj_money Excel Worksheet Functions 1 August 11th 06 09:54 PM
Need help with an embedded IF statement Lari Excel Worksheet Functions 8 June 17th 06 04:59 PM
list embedded in an if statement rk0909 Excel Discussion (Misc queries) 0 March 14th 06 03:45 PM
reducing the number of times an IF statement needs to be calculated in embedded IF statements Harold Good Excel Discussion (Misc queries) 4 November 17th 05 06:36 PM


All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"