It will have to be a user input. Whenever the user inputs that a deal was split with another salesman (indicated by text in the Split Consultant column), there will have to be some way for the user to specify whether or not they signed out the deal. If they did, then the Product % factors in, if they did not, that particular deal needs to be omitted from the Product % formula.

Does that clarify?