Devise a formula to add non numerical data

[Karin-LRC]

How do I devise a formula that will add the number of items (non numerical
vaule) placed in a column? I am making a list and I want to create a formula
that would add all of the entries that I add to the list. Basically,
calculating how may items are in the list.

 

[akphidelt]

You can use

Count --- This will count up all the cells with values that you have selected
Counta --- This will count all cells in the range including blanks
Countif--- You can count cells that meet a certain criteria

 

[Gord Dibben]

Counta exclude blanks.


Gord Dibben MS Excel MVP