Formula error

Leighmercado

What is wrong with my formula?

=COUNTIFS({MBF Open SB Range 3}, "737", {MBF Open SB Range 4}, "top kit")

I made sure that the column with "737" and "top kit" are both text/numbers but im still getting 0 as total

Find more posts tagged with

Accepted answers

AKnight

Hey @Leighmercado !

I would add CONTAINS like:

=COUNTIFS({MBF Open SB Range 3}, CONTAINS("737", @cell), {MBF Open SB Range 4}, CONTAINS("top kit", @cell))

Does this work?

All comments

AKnight

Hey @Leighmercado !

I would add CONTAINS like:

=COUNTIFS({MBF Open SB Range 3}, CONTAINS("737", @cell), {MBF Open SB Range 4}, CONTAINS("top kit", @cell))

Does this work?

Leighmercado

Yes, it worked! thank you very much!!!

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.