How do I count cells with data?

=COUNTA(B:B)

for example.

--

Vasant

"darin " wrote in message
...
I need to know how to setup a formula that will count the number of
cells in a column with data in them. I put text in the cells so there
are no numbers to count. It has to be dummy proof because I need to
share this with my sites.

Thanks,
Darin


---
Message posted from http://www.ExcelForum.com/

Thanks... Works exactly how I need it to work.


---
Message posted from http://www.ExcelForum.com/

I have a similar issue - but I want to count the number
of times a specific text string occurs in a list. I have
tried the COUNTD functions but with no success.

Can you help?

WG
-----Original Message-----
=COUNTA(B:B)

for example.

--

Vasant

"darin " wrote in
message
...
I need to know how to setup a formula that will count
the number of
cells in a column with data in them. I put text in
the cells so there
are no numbers to count. It has to be dummy proof
because I need to
share this with my sites.

Thanks,
Darin


---
Message posted from http://www.ExcelForum.com/



.

Hi
try
=COUNTIF(A1:A1000,"textstring")
-----Original Message-----
I have a similar issue - but I want to count the number
of times a specific text string occurs in a list. I have
tried the COUNTD functions but with no success.

Can you help?

WG
-----Original Message-----
=COUNTA(B:B)

for example.

--

Vasant

"darin " wrote in
message
...
I need to know how to setup a formula that will count
the number of
cells in a column with data in them. I put text in
the cells so there
are no numbers to count. It has to be dummy proof
because I need to
share this with my sites.

Thanks,
Darin


---
Message posted from http://www.ExcelForum.com/



.

.