Having Trouble with SUMIFS

Options
Jessb9187
Jessb9187 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to create a condition based upon user submitted data for over budget flight requests. If the flight type is a One-Way, then whatever the pre-tax amount should be subtracted by the budget amount to give me the over budget amount. This formula is =SUMIFS([Flight Cost (Pre-Tax)]1 - 350, [Flight Type]1, "One-Way")

However, if the flight type is a Round Trip or a Multi-City flight, the number needs to be subtracted from 700 and for the life of me, I cannot figure out how to create this additional condition in the formula. Everything I try comes back Invalid Argument Set or Unparseable. 

I've tried all the combinations of commas, spaces, AND/OR functions and even continuing in the SUMIF formula criterion2 and so on doesn't seem to work. That returns and Invalid Argument? What am I doing wrong?

SUMIFS.JPG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!