Sheet Summary formula COUNTIFS with two criteria in one column

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 "")

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.