I can not figure out what is wrong with my CountIFs formula

I have a formula that returns the number of Volunteers we have signed up IF they are assigned to any stand (it will not count them if they are assigned Waitlist or $$). My current formula that IS working is: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$")

It works great. However, I want to add in that the Volunteer should NOT be counted if they are listed as a No Show (they didn't show up, which is noted in the Lead column)

I attempted to do this by adding (Lead:Lead), <> "No Show" My entire formula I used was: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$", (Lead:Lead), <>"No Show")

However, when I do this to the formula, it returns the value of 0. The value was 3 prior to adding the No Show part of the formula. What am I missing? It seems like it must be something so simple.

Find more posts tagged with

Accepted answers

bisaacs

Hey @RiseUpPNW,

To clarify, it should only count if a contact is entered, they're not on the waitlist or $$, and they're not a no show?

Nic Larsen

Nothing jumps out to me as why it wouldn't work. I did try a slightly different version if you want to give this one a try. It worked for me:

=COUNTIFS(Contact:Contact, NOT(ISBLANK(@cell)), STAND:STAND, NOT(OR(@cell = "*Waitlist", @cell = "$$")), Lead:Lead, NOT(@cell = "No Show"))

All comments

bisaacs

Hey @RiseUpPNW,

To clarify, it should only count if a contact is entered, they're not on the waitlist or $$, and they're not a no show?

Nic Larsen

Nothing jumps out to me as why it wouldn't work. I did try a slightly different version if you want to give this one a try. It worked for me:

=COUNTIFS(Contact:Contact, NOT(ISBLANK(@cell)), STAND:STAND, NOT(OR(@cell = "*Waitlist", @cell = "$$")), Lead:Lead, NOT(@cell = "No Show"))

RiseUpPNW

@bisaacs Correct!

bisaacs

Hey @RiseUpPNW,

It appears the formula won't count a row if the Lead column is empty using your formula, but @Nic Larsen's works!

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.