+ Reply to Thread
Results 1 to 2 of 2

COUNTIFS with Multiple Criteria in One Range

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    100

    COUNTIFS with Multiple Criteria in One Range

    Hello --

    I am trying to count the number of times the below text shows up in a column. I'd like to keep it simple, so no adding adding the Countif formulas.

    My current formula is below:
    =COUNTIF(DATA!$AQ:$AQ,{"DOCTORAL";"MASTERS";"NULL/ND"})

    It is only counting Doctoral, not Masters or NULL/ND.

    Thanks.

  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 with Multiple Criteria in One Range

    Put it in a SUM function

    =SUM(COUNTIF(DATA!$AQ:$AQ,{"DOCTORAL","MASTERS","NULL/ND"}))

+ 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. Countifs with multiple criteria in a single range
    By Wolfpackfan320 in forum Excel General
    Replies: 1
    Last Post: 02-27-2012, 04:54 PM
  3. Countifs in VBA. Loops on criteria range
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-31-2011, 06:35 PM
  4. Replies: 0
    Last Post: 07-27-2011, 01:00 AM
  5. COUNTIFS with a range of values for criteria
    By sslack88 in forum Excel General
    Replies: 3
    Last Post: 11-03-2008, 03:14 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