IF/AND/OR Assistance Needed!

Sam McDonald

I'm trying to pull up the number of product sales by Region. Region is a multi select column. t works perfect when there's only once instance of MEA - SA or MEA - ME but there's one instance where I have both MEA - ME and MEA - SA in the same cell. I'm struggling on how to combine all three options together. Essentially if Region has MEA - ME or MEA - SA or MEA-ME and MEA-SA.

This works perfect when Region has either one or the other:

=SUMIFS({Target # Sales}, {Month}, "January", {Region}, OR(@cell = "MEA - ME", @cell = "MEA - SA"), {Focus Products}, HAS(@cell, $[Focus Product]@row)

I tried this for all three instances but it then comes up as 0:

SUMIFS({Target # Sales}, {Month}, "January", {Region}, OR(AND(@cell = "MEA - ME", @cell = "MEA - SA")), {Focus Products}, HAS(@cell, $[Focus Product]@row))

AravindGP

Hi @Sam McDonald

You can try this formula instead

=SUMIFS({Target # Sales}, {Month}, "January", {Region}, OR(CONTAINS("MEA - ME", @cel), CONTAINS("MEA - SA", @cell)), {Focus Products}, HAS(@cell, $[Focus Product]@row))