How would I do a Nested CountIF statement where I countif and then do a calculation based on the results?
see formula below
=COUNTIF(C6:C9,"*Direct*")+COUNTIF(C6:C9,"*Fixed*")+COUNTIF(C6:C9,"*Travel*")
want value just to be "1" if any a true and then multiple the "1" value by $125
Bookmarks