Hi and thank you in advance for your help!
I am a teacher trying to keep track of completion of distance learning assignments across several classes.
I need for my formula to check the number of "Complete" across a range of cells and then return "Complete" if there are 5, "None" if there are 0, and "Some" if there are 1-4.

I can nest one COUNTIF statement within the IF statement to return "None" or "Some", but I am unsure of how to alter the formula to include "Complete" if there are 5.
This is the formula I am using:
=IF(COUNTIF(C2:G2, "Complete")=0, "None", "Some")

In this case:
Complete.JPG
I need for the formula to return "Complete"

Ideas?