Help with OR formula

Hi,

I'm trying to use the formula as below, it does not seem to work for me.

=COUNTIFS({product type}, "type1", OR({product type}), "type2", {supplier}, $suppliername1, {product or service}, "product", {status}, "")

Basically I want to count the number of blank status that are a "product", within type1 and type2 for product type.

The {product type}, {supplier}, {product or service} and {status} are reference from another single sheet.

Find more posts tagged with

Accepted answers

Thinh Huynh

Hi @HueyD,

Due to OR usage for type1 or type2 of the product, I suggest to use total caculation as below. Try this one :

=COUNTIFS({status}, "", {product type}, "type1", {supplier}, $suppliername1, {product or service}, "product") + COUNTIFS({status}, "", {product type}, "type2", {supplier}, $suppliername1, {product or service}, "product").

Hope it help!

All comments

Thinh Huynh

Hi @HueyD,

Due to OR usage for type1 or type2 of the product, I suggest to use total caculation as below. Try this one :

Hope it help!

HueyD

thank you very much, the formula 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.