I have Excel 2000. I have blank cells and cells with text data (not
numbers). I want to count the number of cells in a range that have data in
them and to have the blank cells not be counted. What is the function for
this?

Thanks!
Kathy

Kathy, use counta, like this, =COUNTA(A1:A10)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kathy" wrote in message
...
I have Excel 2000. I have blank cells and cells with text data (not
numbers). I want to count the number of cells in a range that have data
in
them and to have the blank cells not be counted. What is the function for
this?

Thanks!
Kathy

Super! It worked wonderfully. Thank you!

"Paul B" wrote:

Kathy, use counta, like this, =COUNTA(A1:A10)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kathy" wrote in message
...
I have Excel 2000. I have blank cells and cells with text data (not
numbers). I want to count the number of cells in a range that have data
in
them and to have the blank cells not be counted. What is the function for
this?

Thanks!
Kathy