COUNTIFS

I know this should be easy but I just can't get it right. Trying to count instances of 2 different values in the same column. There are 6 options within the dropdown in the column but I only want to capture the amount of 2 specific values, "Seller Rep" and "Fee"

Tried every variation I can imagine of this: =COUNTIFS([Listing Type]31:[Listing Type]145, "Seller Rep", or "Fee"])

With quotes, without, but always get #UNPARSEABLE. Maybe wrong formula type?

Anyone able to help? It's slaying me!

Thanks

Find more posts tagged with

Formulas

Accepted answers

Mike Wilday

Try this.

=COUNTIFS([Listing Type]31:[Listing Type]145, OR(@cell = "Seller Rep", @cell ="Fee"))

When using the or formula you have to encase the different parameters inside of parenthesis after OR and separate them with a comma. You also have to use the @cell parameter to indicate that as it checks each cell in the range either of those parameters are looked at.

All comments

Mike Wilday

Try this.

=COUNTIFS([Listing Type]31:[Listing Type]145, OR(@cell = "Seller Rep", @cell ="Fee"))

Mike Carroll

Awesome! Thank you!

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.