count
 

Hi al,
I'm using the following function to count rows:
=COUNT(B121:B140)
As you can see,all the rows are 20,in my excel sheet only 11 of them contain
text and 9 are empty..,but actually when i use the above function i get the
result 9 not 11
Can anybody help?
Regards

count
 

Your formula works perfectly and will count the number of cells in your range
that contain numbers. Count will not count text values, if you want to count
text and number values use COUNTA which counts the cells in a reange that are
not empty.

Mike

"Pietro" wrote:

Hi al,
I'm using the following function to count rows:
=COUNT(B121:B140)
As you can see,all the rows are 20,in my excel sheet only 11 of them contain
text and 9 are empty..,but actually when i use the above function i get the
result 9 not 11
Can anybody help?
Regards

count
 

Count returns the number of cells that contain numbers. I think you want
CountA()

"Pietro" wrote:

Hi al,
I'm using the following function to count rows:
=COUNT(B121:B140)
As you can see,all the rows are 20,in my excel sheet only 11 of them contain
text and 9 are empty..,but actually when i use the above function i get the
result 9 not 11
Can anybody help?
Regards