+ Reply to Thread
Results 1 to 3 of 3

Count if multiple criteria

  1. #1
    Registered User
    Join Date
    05-14-2014
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    34

    Count if multiple criteria

    I have a sheet containing two rows
    first rows I have passing marks B1:H1
    second row I have obtained marks B2:H2
    I want to display "promoted" in result column
    if a student fail in 2 subjects (if Passing marks < obtained marks) but
    if he has total marks B2:H2 greater than 182 he should be promoted.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,016

    Re: Count if multiple criteria

    Administrative Note:

    Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    179

    Re: Count if multiple criteria

    Quote Originally Posted by kashifshahzad View Post
    I have a sheet containing two rows
    first rows I have passing marks B1:H1
    second row I have obtained marks B2:H2
    I want to display "promoted" in result column
    if a student fail in 2 subjects (if Passing marks < obtained marks) but
    if he has total marks B2:H2 greater than 182 he should be promoted.
    Your logic and instructions are not clear. But, guessing here, I supposed this might do what you are aiming for : =IF(AND(SUMPRODUCT(--(B2:H2<B1:H1))>=2,SUM(B2:H2)<=182),"Fail","Promoted")

+ 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. Replies: 7
    Last Post: 04-07-2021, 06:04 PM
  2. [SOLVED] Formula to count matches between multiple columns on different sheets w/ multiple criteria
    By RICK JAMES in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2019, 03:28 PM
  3. Count with multiple criteria (Date, Time and Other Criteria)
    By Naren_Kumar in forum Excel General
    Replies: 6
    Last Post: 06-25-2018, 05:53 PM
  4. Count cells if any criteria are met, not multiple criteria
    By jesstaylor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2014, 12:50 PM
  5. 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
  6. 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
  7. 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

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