How to count cells that have ANYTHING in them.
Sometimes we need to know how many entries we have in a list, irrespective of whether it is text or numbers. The Count () function, covered in this tutorial , ONLY counts entries with numbers in them but if you need to know, for example, how many names you have in a list, then you should use Counta(). Think of it as Count – Anything.
We are going to look at 2 ways to get this number
- From the status bar
- Using the Counta() function
Here is the file you can use to practise on.