number of cells containing text
 

I am looking for a formula that sums the number of cells in a range that I
choose that are not blank (contain some text or date), for example assigning
a value of 1 to each cell containing a name and then giving me the number of
cells in that range that contains a name (also assume that every nonblank
cell contains a name). I am looking to do this with a range (A1:A20) so that
I can insert cells into that range and still have the formula calculate. Can
someone please help?

number of cells containing text
 

You may use the formula COUNTA directly, that counts non blank cells in a
range:
=COUNTA(A1:A20)

Hope this helps,
Miguel.

"Xhawk57" wrote:

I am looking for a formula that sums the number of cells in a range that I
choose that are not blank (contain some text or date), for example assigning
a value of 1 to each cell containing a name and then giving me the number of
cells in that range that contains a name (also assume that every nonblank
cell contains a name). I am looking to do this with a range (A1:A20) so that
I can insert cells into that range and still have the formula calculate. Can
someone please help?