Countif with multiple criteria
I am trying to create a countif formula with multiple criteria with one being the approval status and the other being scheduled (which is a date and I want to count it as "1").
I'm trying =countifs(range1, "Approved") +countif(range 2, ???)
The question marks if where I am having issues. The column is formatting as a date not text/number so that may be the issue. I tried =countifs(range1, "Approved") +countif(range 2, NOT(ISBLANK(@cell)) and it returned a wrong number.
Any suggestions? I'm getting really frustrated.
Help Article Resources
Check out the Formula Handbook template!