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
    Location
    Europe, Croatia
    Posts
    900
    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")
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  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
    Location
    Europe, Croatia
    Posts
    900
    Articles
    0
    Excel Version
    Excel 2013
    Do not we complicated the issue
    Can you set the example files and the results you want
    regards
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  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
  •