COUNTIFS OR Function Error
I'm attempting to create a formula that will count the number of requests that are pending review. The column uses a drop down menu with three options, Submitted, Approved, or Declined. I'm trying to create a count in the Sheet Summary to count the number of requests that are still pending approval. The options that it looks for are "Submitted" or a blank cell.
=COUNTIFS([BLC Approval]:[BLC Approval], "Submitted", OR [BLC Approval]:[BLC Approval], "")
The above formula is returning an unparseable error. I suspect it has to do with the ending part of the formula. However, I can't figure out what to put for the second half in order for the formula to count a blank cell.
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!