Not sure what you are trying to do. Seems like you want to add something if those conditions are true; maybe a SUMIFS is appropriate? Or, just an IF statement, and then you know what to put in the if_true and if_false sections? Are you assuming the % and * are wildcards or exact matches? I assume * is a wildcard for multiple letters.