Sheet Summary formula COUNTIFS with two criteria in one column

ldavies95

I am trying to make a sheet summary formula to generate the total number of cells that are either blank or have Submitted within them. So far I have tried multiple different formulas and this is the one I am currently testing however it comes back as #UNPARSEABLE

=COUNTIFS([Site Supervisor Approval]:[Site Supervisor Approval], "Submitted, OR "")

Corey W.

I think your syntax is off for the OR statement. Try:

=Countif([Site Supervisor Approval]:[Site Supervisor Approval],OR(@cell="",@cell="Submitted"))

ldavies95

=COUNTIF([Site Supervisor Approval]:[Site Supervisor Approval], OR(@cell= "", @cell= "Submitted"))

I just tried the above and it still returns #UNPARSEABLE

Paul Newcome

Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?

ldavies95

Paul Newcome

I have tried this one

=COUNTIF([Site Supervisor Approval]:[Site Supervisor Approval], OR(@cell= "", @cell= "Submitted"))

and also this one

=COUNTIFS([Site Supervisor Approval]:[Site Supervisor Approval], "Submitted, OR "")

as well as a slew of other variations similar and all come back #UNPARSEABLE

Paul Newcome

Ok. What about a screenshot of the formula open in the sheet as if you are about to edit it? There are certain indicators that could help with troubleshooting.