Adding prices in a column if there are multiple statuses identified

Alex Madche

Hi Everyone,

I have no training in formulas and am only self taught. I cannot seem to figure out how to create a code for this situation, thank you in advance for your help!

I would like the formula to add up the dollar values of one column when there are certain statuses selected in a second column, and also is identified as Q1 in a third column. I tried to build the formula and got 'unparseable":

=SUMIFS({Tracker Range 1}, ({Tracker Range 2}, "Approved", OR("Postponed", ({Tracker Range 3}, "Q1"))))

Heather Duff

Hi Alex,

You're doing great! You're very close. Let me make sure I understand what you want:

Add the items in Tracker Range 1 that meet the following criteria: Tracker Range 2 equals either Approved or Postponed, AND Tracker Range 3 equals Q1.

If so, it would look like this:

=sumifs({tracker range 1}, {tracker range 2}, OR(@cell="Approved",@cell="Postponed"), {tracker range 3}, "Q1")

Let me know if it works!

Best,

Heather

Heather Duff

Hi Alex,

You're doing great! You're very close. Let me make sure I understand what you want:

Add the items in Tracker Range 1 that meet the following criteria: Tracker Range 2 equals either Approved or Postponed, AND Tracker Range 3 equals Q1.

If so, it would look like this:

=sumifs({tracker range 1}, {tracker range 2}, OR(@cell="Approved",@cell="Postponed"), {tracker range 3}, "Q1")

Let me know if it works!

Best,

Heather

Alex Madche

OMG Thank you! I am so excited to get a response, this community is great. This is exactly what I was looking for thank you for your help.

Alex