fbpx

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

 

play-sharp-fill

 

 

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