+ Reply to Thread
Results 1 to 4 of 4

Count if function for audit checklist

  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    Charlotte
    MS-Off Ver
    Excel 2010
    Posts
    26

    Count if function for audit checklist

    Example 1.xlsx
    I'm trying to build a QC checklist that scores each correct or incorrect line item.
    I can get a coulple of criteria covered, but I can't get it to look for a value in all three columns and return the score i need based on the box checked. Each line item should only have one item selected and some line items may carry more weight than others.

    Looking to return a value of 0 if B3=x, C3= "", N3=""
    Looking to return a value of 5 if B3="", C3="x", N3=""
    Looking to return a value of 0 if B3="", C3= "", N3="x"
    In some instances an "x" in c may only be worth 1.

    Please see my attachment and let me know if you have any questions.
    Thank you in advance for the help

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Count if function for audit checklist

    =IF(AND(B3="",C3="x",D3=""),5,0) drag it down

  3. #3
    Registered User
    Join Date
    07-29-2011
    Location
    Charlotte
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Count if function for audit checklist

    Thank you for the response. I can get this far and I'm sorry if my question wasn't clearer.
    =IF(AND(B3="",C3="x",D3=""),5,0) If I have this, how do I add to it to potentially include an x in either column B or C. I'd like the formula to search all three columns and return a 1 if there is an x in B3 or D3 and only return a 5 if there is an x in C3. I'm trying to scan three columns and return two different values depending on the location of the x. I tried to combine if formulas, but kept getting an error.

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Count if function for audit checklist

    Change the 0 to 1

    =IF(AND(B2="",C3="x",D3=""),5,1)

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1