COUNTIF and...

Jessica GriffinJessica Griffin ✭✭✭✭
edited 06/30/21 in Formulas and Functions
06/30/21 Edited 06/30/21

=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7)

I have this working, however how do I add Only if the Status column from origin sheet is not complete?

I've tried variations around this...

=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>Complete)

Best Answer

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    Accepted Answer

    @Jessica Griffin 

    Could you please share me as an admin on a sample copy of your sheet (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    PMP Certified

    [email protected]

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Sign In or Register to comment.