Excel count text
If we want to count the number of names (or list of entries with mixed text and numbers), the count function will not work – simply because it is designed to count NUMBERS only.
In this case we have to use the CountA function. See video below
As always here is the file you can practise on and now you should be well able to count text in excel