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


[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/06-counta_demo.m4v’]



As always here is the file you can practise on and now you should be well able to count text in excel