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!

Attached Files

TEMP.xlsx (8.9 KB, 17 views)

I got it figured out guys! I knew I was over thinking it thanks!!!

The solution is attached.

Attached Files

TEMPv1.xlsx (9.7 KB, 6 views)