How to combine a COUNTIF and a COUNTIFS formula

06/30/21
Accepted

I need to get a number of how many contracts were approved, not approved, pending in April, May, June, etc. of the same year. The following formulas work separately to give me:

  • The count of contracts approved =COUNTIF(AND([Status]:[Status], "Approved")
  • The count of April dates in column =COUNTIFS([Deadline]:[Deadline], IFERROR(MONTH(@cell), 0) = 4)

However, I need to combine them to show count of contracts approved in April, etc. When I have tried to combine them, I get an unparseable message. As always, thanks for the amazing help from this forum!


 

Best Answer

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    Accepted Answer

    Hi @Profe17

    Hope you are fine, please try the following

    =COUNTIFS([Deadline]:[Deadline], IFERROR(MONTH(@cell), 0) = 4,[Status]:[Status], "Approved")

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ 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"

Answers

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    Accepted Answer

    Hi @Profe17

    Hope you are fine, please try the following

    =COUNTIFS([Deadline]:[Deadline], IFERROR(MONTH(@cell), 0) = 4,[Status]:[Status], "Approved")

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ 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"

  • Works perfectly! Thanks!

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    edited 07/01/21

    @Profe17

    You are welcome and I will be happy to help you any time.Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ 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.