count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Count returns the number of cells that contain numbers. I think you want
CountA()
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average problem 1
About references 1
COUNT function - # of occurences a number appears in all cells 26
Count Blanks bw Data 1
Count Formula 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting how many numbers and letters appear in a particular row 7
Need to count a set of numbers in a range 4

Back
Top