COUNTIFS with criteria from 2 columns and 'not blank'

Hi community

I'm trying to code to get a number of entries that meet criteria from 2 columsn, with one being a specific wording and the other being not blank.

I'm using this formula:

=COUNTIFS(Region:Region, "Perth/South West/Wheatbelt"), [Dietary Requirements]:[Dietary Requirements], NOT(ISBLANK(@cell)))

And it is returning unparseable. I can split the parts and use each side of the function independently with success, but can't seem to combine. Pls help :)

Find more posts tagged with

Accepted answers

All comments

KPH

You have a parenthesis closing the COUNTIFS after Wheatbelt (probably left over from when you split the formula up). Try removing it.

=COUNTIFS(Region:Region, "Perth/South West/Wheatbelt", [Dietary Requirements]:[Dietary Requirements], NOT(ISBLANK(@cell)))

KPH

Thank you for the ❤️

If you can, please mark the question as answered so others know you’re problem is solved.

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.