+ Reply to Thread
Results 1 to 3 of 3

Help with countifs or sumproduct with multiple criteria function

  1. 11-18-2015, 10:06 PM #1
    thezwashere
    thezwashere is offline
    Registered User
    Join Date
    07-31-2015
    Location
    Tokyo, Japan
    MS-Off Ver
    2010
    Posts
    9

    Help with countifs or sumproduct with multiple criteria function

    Hi,

    I am trying to use either countifs or sumproduct to add up to criter (Pass and Maybe)

    I am getting it to work with one, but the second is not working.

    I have attached the document.

    Any suggestions?

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-18-2015, 11:04 PM #2
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,373

    Re: Help with countifs or sumproduct with multiple criteria function

    you can do it this way :

    =COUNTIF(E9:E63,"pass")+COUNTIF(E9:E63,"maybe") or

    =SUMPRODUCT((F9:F75="pass")+(F9:F75="maybe"))
    Reply With QuoteRegister To Reply
  3. 11-18-2015, 11:26 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Help with countifs or sumproduct with multiple criteria function

    Try this...
    =SUM(COUNTIF(F9:F75,{"pass","maybe"}))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using COUNTIFS Function With Multiple Criteria
    By Kingswood in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-16-2015, 05:36 PM
  2. How to use countifs function for multiple criteria
    By Terressa in forum Excel General
    Replies: 1
    Last Post: 06-25-2015, 08:08 AM
  3. [SOLVED] Require Sum(Index or SUMPRODUCT or COUNTIFS forumula with multiple criteria
    By Quasis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2015, 05:02 AM
  4. ranking with sumproduct or countifs with multiple criteria
    By cwchan220 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2014, 04:12 PM
  5. [SOLVED] COUNTIFS using multiple criteria - maybe an OR function?
    By Calder in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2014, 12:10 PM
  6. [SOLVED] Sumproduct / Countifs multiple criteria
    By Biffer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2013, 11:08 AM
  7. [SOLVED] Need to use either COUNTIFS or SUMPRODUCT to count rows based on multiple criteria
    By erabinov in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-15-2013, 03:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1