+ Reply to Thread
Results 1 to 2 of 2

Countifs problem - Using the "OR" function or someting similar

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Countifs problem - Using the "OR" function or someting similar

    Hi all,

    The attached spreadsheet is an example of my problem. In the spreadsheet, in cell F2, I provide the countifs formula that I tried to use to count based on multiple criteria, and I'm having a problem with "Criteria 2" in the formula. For criteria 2, I tried to insert an "OR" argument because I want to count cells that contain two types of text, but it's not working.

    Is there a correct way to use the "OR" function here, or is there another way to achieve this?

    Thanks so much for any help with this!
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Countifs problem - Using the "OR" function or someting similar

    Try

    =SUM(COUNTIFS(Trials[Trial Number],E2,Trials[Status],{"Not Selected","In Progress"}))

+ 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: 4
    Last Post: 11-17-2013, 12:05 PM
  2. VBA: Using "<=" symbol with Countifs Function
    By vidyuthrajesh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2013, 08:33 PM
  3. [SOLVED] Function similar to "Sumif"
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2012, 10:39 AM
  4. Replies: 10
    Last Post: 01-26-2012, 08:26 AM
  5. cell references in "COUNTIFS" function
    By mmrtech in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2007, 04:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1