+ Reply to Thread
Results 1 to 4 of 4

Using countifs with Multiple Criteria

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Using countifs with Multiple Criteria

    I'm having trouble getting countifs to work when I have multiple criteria that needs to be matched to a cell range. It seems to work with no issue when there is one criteria and one cell range in a countif statement, but will not work with multiple criteria in a countifs function. The only way I made it work is do a sum and count each criteria individually. It seems there has to be a better way to do it. The attached spreadsheet is a simple example of what I'm trying to do. I've left the formula with the error as well.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,427

    Re: Using countifs with Multiple Criteria

    You could paste the following formula in J2 and drag down to J6 then sum J2:J6
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-22-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Using countifs with Multiple Criteria

    Quote Originally Posted by JeteMc View Post
    You could paste the following formula in J2 and drag down to J6 then sum J2:J6
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    I'm not sure I follow how this works. It doesn't seem to work correctly for me. Below are the results I get and I'm not sure I understand what it is counting.

    Code Count
    GS 0
    CS 1
    NS 0
    LB 1
    RB 2
    Pending 0

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,427

    Re: Using countifs with Multiple Criteria

    Paste the following formula in J7:
    Please Login or Register  to view this content.
    This is the sum of the codes that have a status of "P", which in the case of your example is 4.
    Let me know if you have any questions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countifs with multiple criteria in single criteria range
    By MCP313 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2016, 03:51 AM
  2. [SOLVED] COUNTIFS with multiple criteria in the same criteria range
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2015, 01:04 PM
  3. [SOLVED] countifs statement with multiple criteria for multiple criteria ranges
    By mcdermott2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2015, 11:48 AM
  4. [SOLVED] Countifs multiple criteria, and 1 criteria Less than & Greater than
    By david gonzalez in forum Excel General
    Replies: 4
    Last Post: 06-30-2014, 10:33 PM
  5. [SOLVED] COUNTIFS with one of multiple criteria
    By bibu in forum Excel General
    Replies: 5
    Last Post: 03-23-2014, 08:01 AM
  6. [SOLVED] Countifs with multiple criteria and one criteria has a list of names
    By Beefy1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2014, 05:25 PM
  7. Replies: 0
    Last Post: 07-27-2011, 01:00 AM

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