Hi there I am looking for a formula that counts the amount of completed cells (ie containing content) - but exclude the value 'No' and gives me the percentage of a range completed

Can you help?