Help with OR formula

HueyD

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.

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!

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!

HueyD

thank you very much, the formula works :)