Hopefully I can make myself clear with this one!

I am currently using the COUNTA formula to count non blank cells for a specific range but need to if possible to exclude from the count cells that contain specific data as well a blank data.

I'll try and explain!

The data I wish to exlude in the count are cells that are blank AND contain either Block, Not AM or Not PM

Eg:
Cell A1 = John
Cell A2 = Block
Cell A3 = Not AM
Cell A4 = Graham
Cell A5 is blank (no data)
Cell A6 = Sue
Cell A7 = Not PM

I need a formaular that will look at cells A1:A7 and will return the figure 3 as in my example (i.e. A1 as it contains John, A4 as it contains Graham and Cell A6 as it contains Sue as the other 4 are either blank or contain Block, Not AM or Not PM.

Hope this is clear and any help will be very much appriciated.

Many thanks
John