Quote Originally Posted by Pauleyb View Post
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.
Sorry for not being more clear but I am trying to count the instances of "ApplicationName" if the other underlying conditions are true. I just had the % to show an application name, nothing significant or relevant. Where the * is a multiple wild card for the other conditions that must be true to count.