Help Please!
I have attached a copy of an excel sheet that I'm currently working on. I'm trying to figure a formula that will set a score of 0 in C5 if there is a no entered in C2:C4. I currently have a countif entered in D4.
Also I need the formula to set a score of 50 in C5 if there are all yes' in C2:C4.
I'm sure this can be done, and I'm just over thinking this wayyy to much.
Thank you guys for any suggestions!
Last edited by sammielou; 06-16-2016 at 07:45 AM.
Reason: Figured It out!
|