+ Reply to Thread
Results 1 to 3 of 3

Count If with Multiple Criteria

  1. #1
    Registered User
    Join Date
    07-12-2014
    Location
    Italy
    MS-Off Ver
    2003
    Posts
    2

    Count If with Multiple Criteria

    Hi Guys! I need a little help, if possible, with a Excel formula.
    Assuming a column (M7:M200) has this information:

    John
    Mary
    Lisa
    Mark
    John
    Albert
    |_Empty _|
    |_Empty _|
    |_Empty _|

    I would get the sum of the cells except "empty", "John" and "Mark".
    The result would be: John: 2 | Mark: 1 | Others: 3 (My only interest is the formula to get the result "Others: 3")
    I tried with this formula: = COUNTIF (M7:M200, "<> John") but remains exclude "empty" cells and "Mark."
    Thank you for your attention. THX!

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Count If with Multiple Criteria

    try
    =COUNTA(M7:M200)-SUM(COUNTIF(M7:M200,{"john","mark"}))
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    07-12-2014
    Location
    Italy
    MS-Off Ver
    2003
    Posts
    2

    Thumbs up Re: Count If with Multiple Criteria

    YES!Thank you for your quick reply, martindwilson!

+ 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. Count number of Rows with multiple criteria (multiple valued cells)
    By garog in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-09-2014, 01:33 PM
  2. Multiple Criteria search and COUNT FOR TEXT across multiple sheet ARRAY's
    By akaushik25 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2014, 08:58 AM
  3. Replies: 1
    Last Post: 02-21-2014, 09:09 PM
  4. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  5. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
    By gtj_global in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2008, 06:40 PM

Tags for this Thread

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