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
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version


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