On Excel, say I have 11 cells horizontally. In the first ten cells (A01-A10), there are two possible conditions; yes or no.

I want the 11th cell (A11), to output a text value if a certain criteria is met in the previous ten as follows:

If any four of the ten cells are at yes then 'complete' else 'in progress'

Can you think of a formula that would do that? I'm imagining it's an =(if) but I could be wrong...

The only way I can do it at the minute is by having an additional cell that does a countif across the range and then have the 11th cell evaluate that using a conditional format but there must be a tidier way.

Let me know what you think!? Any help greatly appreciated!!