+ Reply to Thread
Results 1 to 3 of 3

Countifs formulas - use a range of values as the criteria

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Eugene, OR
    MS-Off Ver
    Excel 2010
    Posts
    2

    Countifs formulas - use a range of values as the criteria

    I'm trying to use a range of text values as the criteria in a countifs formula but haven't been successful. There are multiple ranges and criteria being evaluated but this is the only piece i can't get to work.
    Example
    A1 = Dog
    A2 = Cat
    A3 = Rabbit
    A4 = Horse

    basic formula i tried using: countifs(range1,criteria1,K:K,A1:A4,range3,criteria3,etc)
    I'm not sure if this is helpful (as actually posting in a forum is completely new to me) but here is the whole actual formula with the problem area underlined:
    Please Login or Register  to view this content.
    I found a similar post but the cells contained numerical values and the solutions seemed specific to that.
    What i tried obviously doesn't work, but i'm curious if there's a way to achieve the same outcome. Basically, if row K contained any of the values in A1:A4, and met the other criteria, they would be counted.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Countifs formulas - use a range of values as the criteria

    Your formula will return an array of 4 values (one for each cell of 'DV List'!A12:A15) so you just need to wrap another function around that formula to sum the 4 values, i.e.

    =SUMPRODUCT(COUNTIFS('Rec Calls'!$H:$H,'DV List'!$J$1,'Rec Calls'!$L:$L,'DV List'!A12:A15,'Rec Calls'!$G:$G,'DV List'!$C$2))
    Audere est facere

  3. #3
    Registered User
    Join Date
    08-06-2013
    Location
    Eugene, OR
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Countifs formulas - use a range of values as the criteria

    That worked beautifully! I could hug you right now! Thanks so much!

+ 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. [SOLVED] Several formulas with specific range criteria (AVERAGEIFS, STDEV(IF), COUNTIFS)
    By thaphthia in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-11-2013, 05:22 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. Criteria values in COUNTIFS function
    By jsnoz in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-21-2011, 12:46 PM
  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