+ Reply to Thread
Results 1 to 7 of 7

Count cells with multiple criteria

  1. #1
    Registered User
    Join Date
    10-23-2008
    Location
    USA
    Posts
    75

    Count cells with multiple criteria

    Hi forum,

    Here we go... I have another headache...

    I have a column O called Call Score for which I only want to count scores that are less than 70, but only if the date column N is 4/1, 4/2, 4/3, 4/4 and 4/5.

    There, I am clueless...
    Last edited by bmunoz64; 04-05-2009 at 08:24 PM.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Count cells with multiple criteria

    Try

    =COUNTIFS(scores,">70",dates,">="&DATE(2009,4,1),dates,"<="&DATE(2009,4,5))

  3. #3
    Registered User
    Join Date
    04-05-2009
    Location
    Brisbane
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Count cells with multiple criteria

    This looks similar to the help I require. May I ask what I'd type should I want it to select the same but for the entire month of May? (rather than the individual dates specified above).

  4. #4
    Registered User
    Join Date
    10-23-2008
    Location
    USA
    Posts
    75

    Re: Count cells with multiple criteria

    This is absolutely awesome! It worked!

    Forum moderators, this is the best help I have ever had in my professional career.

    I have learned more about Excel in just 3 weeks than my entire work years. Thanks again!!!

  5. #5
    Registered User
    Join Date
    10-23-2008
    Location
    USA
    Posts
    75

    Re: Count cells with multiple criteria

    Try =COUNTIFS(scores,">70",dates,">="&DATE(2009,5,1),dates,"<="&DATE(2009,5,31))

    scores in small caps is actually a column
    dates in small caps is actually a column as well

    good luck!

  6. #6
    Registered User
    Join Date
    04-05-2009
    Location
    Brisbane
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Count cells with multiple criteria

    Awesome, thanks ...and sorry about using the back of your thread to ask.

  7. #7
    Registered User
    Join Date
    10-23-2008
    Location
    USA
    Posts
    75

    Re: Count cells with multiple criteria

    no problem... I ask a lot of questions to the forum so I think it was nice to help someone figure out those formulas...

    Fyi - Microsoft website has a how-to section that is Ok. It helps identify what formula(s) are good for waht you want to accomplish. But then to find out the content of the argument, after you've tried figuring it out on your own, your best bet is the forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1