Results 1 to 5 of 5

Thread: Formula help-- countif, if

  1. #1

    Formula help-- countif, if



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have 2 columns of data. The left column is whether the individual has good or bad behavior. The right column is whether the individual had a positive or negative experience in the emergency room. I have this formula below, which tells me if the one individual had both bad behavior AND a negative emergency room experience.

    =IF(AND(BI10=7,AX10=3),"Yes","No")



    However, I have over 400 individuals in my study. How can I adjust this formula to tell me how many individuals had both bad behavior AND a negative emergency room experience? I'm thinking I have to add COUNT or COUNTIF into the above formula? But I'm not sure how to set this all up.


    Any help would be appreciated. Thank you.

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    You've unclear
    If you copied the formula to the last row then try

    =COUNTIF(range,IF(AND(BI10=7,AX10=3),"Yes","No"))
    =COUNTIF(column-range,"Yes")

  3. #3
    Right now I have this:
    =COUNTIFS(A16:A417,1,B16:B417,7)
    This tells me of the people who selected choice 1 in column A, how many of them also selected choice 7 in column B.

    Now I also need to know, of the people who selected choice 1 in column A, how many of them selected choices 1-6 (all combined together) in column B. Or another way of saying this is I need to find out how many people who selected choice A in column 1 did NOT select choice 7 in column B.
    I tried this, but it's off: =COUNTIFS(A16:A417,1,B16:B417,"=<6")

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    Do not we complicated the issue
    Can you set the example files and the results you want
    regards

  5. #5
    I already figured it out. Thank you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •