+ Reply to Thread
Results 1 to 5 of 5

Counting Number of Cells Based off Criteria of Other Cells in a Different Range

  1. 06-13-2014, 06:49 PM #1
    zooropa33
    zooropa33 is offline
    Registered User
    Join Date
    05-06-2014
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Counting Number of Cells Based off Criteria of Other Cells in a Different Range

    Hi all. Please see attached workbook. The sample numbers below show what I am trying to do, but the actual list is quite extensive.

    I want to count the number of cells that contain a word in column B but only if those cells have a corresponding cell in column A that has the word "BAD" or "OK" in it. This might be incredibly simple, I'm not sure. Any help?

    Thanks so much!

    -Zoo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-13-2014, 06:57 PM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Counting Number of Cells Based off Criteria of Other Cells in a Different Range

    How about:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
  3. 06-13-2014, 06:59 PM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Counting Number of Cells Based off Criteria of Other Cells in a Different Range

    =SUM(COUNTIFS($A$1:$A$9,{"BAD","OK"},$B$1:$B$9,C12))

    I have changed cats to cat so you could use one formula in B13 and drag it to the right

    A
    B
    C
    D
    1
    OK
    dog
    2
    BAD
    cat
    3
    OK
    dog
    4
    12-Jun
    zebra
    5
    BAD
    cat
    6
    13-Jun
    dog
    7
    OK
    dog
    8
    13-Jun
    cat
    9
    OK
    cat
    10
    11
    12
    cat
    dog
    zebra
    13
    3
    3
    0
    Last edited by AlKey; 06-13-2014 at 07:01 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  4. 06-13-2014, 07:02 PM #4
    zooropa33
    zooropa33 is offline
    Registered User
    Join Date
    05-06-2014
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Counting Number of Cells Based off Criteria of Other Cells in a Different Range

    Thank you!
    Reply With QuoteRegister To Reply
  5. 06-13-2014, 07:08 PM #5
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Counting Number of Cells Based off Criteria of Other Cells in a Different Range

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
    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. [SOLVED] Counting number of non blank cells based on contents of diferent range
    By icyoung in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-14-2013, 12:14 PM
  2. [SOLVED] Formula Needed to count a range of cells based on criteria in 2 other cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2013, 04:06 PM
  3. Counting the number of empty cells based on a condition in a range
    By naga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 10:01 AM
  4. [SOLVED] counting number of cells which meet a certain criteria
    By Laurab in forum Excel General
    Replies: 8
    Last Post: 06-19-2012, 08:58 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1