How to combine a COUNTIF and a COUNTIFS formula
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!