Devise a formula to add non numerical data
 

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.

Devise a formula to add non numerical data
 

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

"Karin-LRC" wrote:

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.

Devise a formula to add non numerical data
 

Counta exclude blanks.


Gord Dibben MS Excel MVP

On Mon, 10 Nov 2008 16:45:00 -0800, akphidelt
wrote:

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