Results 1 to 2 of 2

Thread: Countif Formula

  1. #1

    Countif Formula



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

    Hi Everyone!

    Just need some help here on how to count if..
    I need a single formula for column C, with the conditions below:
    1. two columns have date (A & B), C should be 1.
    2. if column A&B is declined, column C should be 0
    3. If column A has date and column B is blank, column C should be 1
    4. If column A is blank and column B has date, column C should be 1


    A2: Feb 11 B2: Feb 12 C2:
    A3: Declined 1 B3: Declined 1 C3:
    A4: March 4 B4: C4:
    A5: B5: March 5 C5:


    Thanks in advance..

  2. #2
    Try

    =IF(A1&B1="DeclinedDeclined",0,IF(OR(AND(ISNUMBER(A1),ISNUMBER(B1)),AND(ISNUMBER(A1),B1=""),AND(A1="",ISNUMBER(B1))),1))

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
  •