Count cells not containing specific text

Hi All

I have two questions

1 How do I count the number of cells that do not contain specific text

In my "sports club" column in the attached document, there are the names of various sports clubs of which some of my clients are members. If they are not a member of a sports club I have simply entered "No". I would like to be able to enter a formula which allows me to count the number of people who are members of sports clubs. I was thinking that the best way of doing this was to count the number of cells that do not contain the word "No". Would I be right in thinking this or is there a better way? Also data will be continually added to this document so I would like to do this without having to alter the formula each time I do so?

2 I would like to find out which sports are mainly played by and preferred by all the females surveyed. I would like to be able to find all of the sports played by females and how many times each sport was chosen by a female. I could do this by searching through the document as it is, as there is currently not a lot of data to work with, but as mentioned earlier, more data will be added so it would be useful if excel could find this information for me.

Thank you in advance for helping me with these questions.

For the first question, Try

=COUNTIFS(E:E,"<>No",E:E,"<>")-1

The -1 is to account for the header E3.

Please award yourself one round of applause on my behalf. This worked great thank you. I have no idea why though. is it possible that you could explain this formula in slightly more detail if possible. Thank you again.

The <> basically means "Not Equal To"
So counif is counting each cell in column E that is Not Equal to No and Not blank

There's two parts in it really
E:E,"<>No" <- this counts NOT Equal to No
and
E:E,"<>" <- this counts NOT Equal To Nothing....Not Blank

Hope that helps.

Yes, That is fantastic. Thank you very much.

I did do this initially but, I'm doing this for somebody at work who is technologically impaired and can just about enter the data. I don't think his brain could handle editing the formula each time he added data.

Thank you anyway.