Having Trouble with SUMIFS

Jessb9187

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?

Sterling

Hi Jess,
I think an IF() formula would work better in this situation. Here is what I put together.
=IF(OR([Flight Type]@row = "Multi-City", [Flight Type]@row = "Round Trip"), [Flight Cost (Pre-Tax)]@row - 700, IF([Flight Type]@row = "One-Way", [Flight Cost (Pre-Tax)]@row - 350, ""))

Hope this helps!

Jessb9187

You are amazing! Thank you so much! That did it!!! 

Sterling

Glad it helped! Hope you have a great day!