CountIFs

Creating a function to count certain states in one function listed below:

=COUNTIFS([Travel State]:[Travel State], OR([Travel State]@cell = "CO", [Travel State]@cell = "TX", [Travel State]@cell = "WA", [Travel State]@cell = "OK", [Travel State]@cell = "NM", [Travel State]@cell = "NE", [Travel State]@cell = "MO", [Travel State]@cell = "MN", [Travel State]@cell = "ID", [Travel State]@cell = "IA"))

However, I receive #Unparsable notification.

Find more posts tagged with

Accepted answers

Carson Penticuff

Give this a try:

=COUNTIFS([Travel State]:[Travel State], OR(@cell = "CO", @cell = "TX", @cell = "WA", @cell = "OK", @cell = "NM", @cell = "NE", @cell = "MO", @cell = "MN", @cell = "ID", @cell = "IA"))

All comments

Carson Penticuff

Give this a try:

=COUNTIFS([Travel State]:[Travel State], OR(@cell = "CO", @cell = "TX", @cell = "WA", @cell = "OK", @cell = "NM", @cell = "NE", @cell = "MO", @cell = "MN", @cell = "ID", @cell = "IA"))

Adarian Searcy

Much appreciated, @Carson Penticuff, this worked.

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.