Adding prices in a column if there are multiple statuses identified

Options

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"))))

Tags:

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Answers

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    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
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!