How to count only cells with names (and not numbers), and other questions.

Hello,

I'm a very big noob at excel and am trying to learn the basics. I'm trying to use advanced filters to count each occurrence of a given name on a new sheet.

I'm encountering 2 problems:

The first problem I have is that sometimes there are dates in the same column as the names, and I don't want to count these dates. There are also blank cells which I do not want to count.
I'm inspired by the following tutorial:
https://www.youtube.com/watch?v=bGUKjXmEi2E
I'd like to filter out the numbers and blank cells so that only the names appear on my new worksheet.
What would be a good formula to only count the names and not the numbers and blank cells?

The second problem I'm encountering is that I only want the names to be counted when a value in the cell to the right is 1 or more. If the cell to the right of the name has a value of 0, the name shouldn't be counted. Again, what would be the best formula for this?

I hope this is clear enough

Thanks in advance for your help.