Calculations based on text color
I am wondering if there is a way to set a calculation to get the sum of fields, but not to include numbers that are a certain color. On my database below I have player salaries that I have a calculation that adds up total player salary. On some contracts there is a qualifying offer listed in a certain color. THe qualifying offer is not part of the contract, but an estimation and I dont need it in the calculation. As you can see I set it a certain color. Not every player has a qualifying offer. Is there a way not to include the qualifying offer in a calculation??