Hi!

I'm trying to figure out a formula for an IF/OR situation. Basically -- if the [Add-ons] column includes the tag "Prebill," I want the [Final Invoicing Amount] column to be "[Total Project Cost] - [Prebill Actual Invoiced]." If it's NOT tagged "Prebill," I want the [Final Invoicing Amount] column to be "[Total Project Cost] - [FD Actual Invoiced]".

I have a formula that works for the first scenario (not written as an IF formula), but I don't know how to make it into an IF formula that will return the other SUM in the OR situation. Here's the formula I have so far (that works): =SUM([Add-Ons]@row, HAS(@cell, "Prebill"), SUM([Total Project Cost]@row - [Prebill Actual Invoiced]@row))

And this is the formula I want it to perform if [Add-ons]@row does NOT have "Prebill": =SUM([Total Project Cost]@row - [FD Actual Invoiced]@row)

So, in theory it should be something like below, but this isn't working: =SUMIF(([Add-Ons]@row, HAS(@cell, "Prebill"), SUM([Total Project Cost]@row - [Prebill Actual Invoiced]@row)), SUM([Total Project Cost]@row - [FD Actual Invoiced]@row))

Any thoughts or suggestions are appreciated!