Add up whats in a column
 

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.

Add up whats in a column
 

Try this:

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

Will count *only* text!
--

HTH,

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


"slavenp" wrote in message
...
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.

Add up whats in a column
 

=COUNTIF(A1:A300,"*")


"slavenp" wrote:

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.

Add up whats in a column
 

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

=COUNTIF(A1:A300,"yes")


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 06:51:04 -0800, slavenp
wrote:

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.