+ Reply to Thread
Results 1 to 4 of 4

Count it multi criteria accross multi cells

  1. 06-10-2013, 03:32 PM #1
    jfoley5197
    jfoley5197 is offline
    Registered User
    Join Date
    06-10-2013
    Location
    Pennsauken, Nj
    MS-Off Ver
    Excel 2007
    Posts
    1

    Count it multi criteria accross multi cells

    I can't seem to build the right formula to make this happen:

    If a = "1" and b = "NO" and c = "NO" and d = "NO" show a "1" in e. If this criteria is not met add a "0" in e.

    Some rows could have a "0" in a or a "YES" in b, c or d and I'm looing to eliminate those from my sum.

    Thanks for your help!
    Reply With QuoteRegister To Reply
  2. 06-10-2013, 03:38 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Count it multi criteria accross multi cells

    Try this one (untested)

    if(and(a1=1,countif(b1:d1,"no")=3),1,0)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 06-10-2013, 03:41 PM #3
    young_86
    young_86 is offline
    Registered User
    Join Date
    10-28-2012
    Location
    Poland
    MS-Off Ver
    Excel 2007/2010
    Posts
    94

    Re: Count it multi criteria accross multi cells

    try this
    =IF(AND((A1=1);(B1="NO");(C1="NO");(D1="NO"));1;0) or
    =IF(AND((A1=1),(B1="NO"),(C1="NO"),(D1="NO")),1,0)

    depend you use ; or ,

    br
    Like to say thanks ?Please use the star icon.
    Reply With QuoteRegister To Reply
  4. 06-10-2013, 03:42 PM #4
    young_86
    young_86 is offline
    Registered User
    Join Date
    10-28-2012
    Location
    Poland
    MS-Off Ver
    Excel 2007/2010
    Posts
    94

    Re: Count it multi criteria accross multi cells

    try this
    =IF(AND((A1=1);(B1="NO");(C1="NO");(D1="NO"));1;0) or
    =IF(AND((A1=1),(B1="NO"),(C1="NO"),(D1="NO")),1,0)

    depend you use ; or ,

    br
    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)

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