Add up whats in a column

S

slavenp

I have a column that I would like to tally up how many times text has been
entered. There are 300 rows and a number of these rows have yes entered - I
would like to know have text. Thanks. Using 2007.
 
R

RagDyeR

Try this:

=COUNTIF(A1:A300,"*?")

Will count *only* text!
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have a column that I would like to tally up how many times text has been
entered. There are 300 rows and a number of these rows have yes entered - I
would like to know have text. Thanks. Using 2007.
 
G

Gord Dibben

A different interpretation............

=COUNTIF(A1:A300,"yes")


Gord Dibben MS Excel MVP
 
Top