I will try to explain the best way I can. I am currently using this formula:
plete - Successful"))+0
It tells me that if the value in C6 is either Complete or Complete - Successful to make it 1, or 100%.
I am wanting to also add to it to check to see if a accounting code matches (Column B on both Sheets), if it does, add the value thats in column K. If not, use the "Complete" or "Complete - Succcessul."
See the attached for an example file. I hope I have explained it well, if not, I will respond asap.