How would up update this existing SUMIFS formula to add an additional criteria?

I have a current formula that but we have realized that there is one Team who's numbers are skewing the results and would like to have there totals excluded.

=SUMIF([Cast Type]:[Cast Type], "Vendor", Estimate:Estimate) + SUMIF([Cast Type]:[Cast Type], "Contractor-Offshore", Estimate:Estimate)

The Additional Column is called "Team" and we would want to exclude any values that correlate to TEAM="TPM", leaving the values for the other teams "Team1", "Team2" for placeholders.

Tags:

Answers

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    =SUMIFS(Estimate:Estimate, [Cast Type]:[Cast Type], OR(@cell = "Vendor", @cell = "Contractor-Offshore"), Team:Team, <>"TPM")

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!