+ Reply to Thread
Results 1 to 2 of 2

COUNTIF with 2 different sets of multiple criteria?

  1. #1
    Registered User
    Join Date
    12-18-2014
    Location
    Chamonix, France
    MS-Off Ver
    Excel 2007
    Posts
    2

    COUNTIF with 2 different sets of multiple criteria?

    Hi guys, been stuck on this for a while now, any advice would be appreciated!

    The column "Child Count" must return 1 if:

    1. Child is under brand name A or B and is older than 1 but younger than 13

    2. Child is under brand name C and is older than 1 but younger than 12

    Originally in the child count column I put the formula:

    =COUNTIFS(F2,">1", F2,"<13")

    ...but of course this only counts children for Brands A and B.

  2. #2
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: COUNTIF with 2 different sets of multiple criteria?

    Can you upload a sample worksheet?

+ 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. [SOLVED] Index Match With 2 Sets of Criteria, Each with Multiple Conditions
    By MrMacro2013 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-23-2014, 06:29 PM
  2. [SOLVED] SUMPRODUCT, COUNTIF formulas not correctly counting based on two sets of criteria
    By justinbelkin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-11-2013, 10:12 AM
  3. Replies: 2
    Last Post: 08-30-2013, 06:30 AM
  4. Replies: 2
    Last Post: 08-22-2012, 01:23 PM
  5. Counting data sets based on multiple criteria
    By hjb0802 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-29-2010, 10:47 AM

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