Easily confused with the COUNT function, the addition of an extra makes all the difference! If you have a list of names that want counting up... use COUNTA! COUNT does not like letters but COUNTA love 'em!
The video shows the COUNTA function in use.
The final written calculation is below:
=COUNTA(B3:B9)
In this formula, B3:B9 is the range of cells, containing text, that we want to count. The answer is 7!
Comments