Hello,
I am trying to figure out how to use the Count or Counta function in Excel.
I have a column of text where each cell contains one of three values. They
are open, complete, on-going, and are located in a specific range of cells
in that column. I want to obtain the total number of each of the three
values.
I have gone into help and based on what I read thought that the following
syntax was what I was supposed to use. , The result I am getting gives the
total number of cells in the range, and not the individual count for one of
the three values.
=counta(g5:g54, "open")
This gave me the result of 48, instead of 21.
What am I doing wrong?
I hope someone out there can help me.
Annette
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Address for the list archives:
http://www.mail-archive.com/[email protected]/
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[EMAIL PROTECTED]
For help from Mailman with your account Put the word help in the subject or
body of a blank message to:
[EMAIL PROTECTED]
Use the following form in order to contact the management team
http://www.jaws-users.com/BlindComputing.php
If you wish to join the JAWS Users List send a blank email to the following
address:
[EMAIL PROTECTED]
