Countifs with Or Function

I'm trying to count people from another sheet where the goal year equals the one reference on the current row and the Status could be a few other options, so I thought the easiest would be the OR function with counting everything including blank, but not "Agent Not in Count".

The formula below gives me an #Unparseable error.

=COUNTIFS({Goal Year}, Year@row, {Status}, OR(@cell <>"Agent Not in Count", @cell ""))

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Andrea Westrich

It looks like you're just missing the = sign for when you're looking for ""!

Try this:

=COUNTIFS({Goal Year}, Year@row, {Status}, OR(@cell <>"Agent Not in Count", @cell = ""))

Cheers,

Genevieve

All comments

Andrea Westrich

@Paul Newcome or @Genevieve P., do you know the answer? The problem is that the Status column can have 1 of 5 options or it can be blank. I need to count blanks and every status except Agent Not in Count.

I appreciate your help!

Genevieve P.

Hi @Andrea Westrich

It looks like you're just missing the = sign for when you're looking for ""!

Try this:

=COUNTIFS({Goal Year}, Year@row, {Status}, OR(@cell <>"Agent Not in Count", @cell = ""))

Cheers,

Genevieve

Andrea Westrich

Hello @Genevieve P.,

You are SO amazing! That worked perfectly! This is so helpful for many uses, I really appreciate your help.

Thank you very much!!

Genevieve P.

No problem at all! I'm glad it was an easy fix 🙂

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.