If / And and a Sum If Formula?

[Mississippi Girl]

Hi - been going in circles with this formula for a while.
I have 2 data sets; one is the base value of services/commodities, etc. with associated fees calculated in Rows 13 and 14; the second data set contains the same data, but at the fully loaded value (with fees calculated on each item vs. at the end).

Fee 1 is applied to everything, no matter what. That's an easy one.
Fee 2 is only applied to Contract Labor and Contract Materials, but only when the sum of Contract Labor and Contract Materials (in cell range O3:O11) is $1M or higher.

Row 15 should equal Row 28.
Can you see what I'm doing wrong? In my mind, this makes perfect sense.
Thanks for your help!

 

[Mississippi Girl]

Try changing this:

$A20="Contract*"

To either of these:

LEFT($A20,8)="Contract"

or

COUNTIFS($A20,"Contract*")

Why does that work? LOL!
Thanks!!

 

[Mississippi Girl]

Did you try either of the suggestions in my Post #6 ?
Mind you for SACOM if you use left you would have to change the 8 to a 5.

Just did and it worked! Thank you so much!

 

[Alex Blakenburg]

The if statement doesn't like wild cards and is always evaluating as FALSE.
Countifs can handle wild cards and will count anything starting with the word before the wildcard.
The if statement treats 0 as FALSE and any other number ie Countifs > 0 as TRUE
You could put Countifs(expression) > 0 if you find that more intuitive.

The left version is probably self explanatory, let me know if its not.