COUNTIFS OR Function Error

Hi,

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

Andrée Starå

Hi @Chloe Rose

Try something like this.

=COUNTIF([BLC Approval]:[BLC Approval], "Submitted") + COUNTIF([BLC Approval]:[BLC Approval], "")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Chloe Rose

Hi Andree,

It has stopped returning the unparseable but it now seems to be counting all the blank cells in the entire sheet which is also not what I want. I only need it to count the number of cells that have submitted or blank in a row that has other data in it. I hope that makes sense.

Andrée Starå

@Chloe Rose

If only the ten blank rows are added by default, you can add -10 to the formula. If it's not, we need to add something to the formula, so it only counts the specific rows.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

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.