Formula needed for counting text

Nathan Winegar

Attached is a sample screen shot of 6 names.  On the seventh cell, what formula do I input so it reads "6"?  I need a way to sum up all of the names in a column.

Nic Larsen

You can use something like this: 

=COUNTIF(Range:Range, NOT(ISBLANK(@cell)))

L_123

or just =

count(Name1:Name6)

would work.

Paul Newcome

I would have to agree with L@123's solution for this one. If you are referencing the entire column, you will get a #CIRCULAR REFERENCE error since the formula is within the range.