If I understand what you're trying to do (obtain the sum of various cells display values), then it's actually more simple, and you don't really need to use a function as such.
Along these lines, if I wanted the sum of the values in A1, A2 and A3, then in another cell I could either use the F2 key to enter editing mode, or else, simply by starting off typing the = character it sort of automatically does it, but anyway, the following content would in fact render the sum mentioned above: =A1+A3+A2 (simply hit enter after typing in the mathematical formulae) HTH Jacob Kruger Blind Biker Skype: BlindZA '...Fate had broken his body, but not his spirit...' ----- Original Message ----- From: "Annette" <[EMAIL PROTECTED]> To: <blind-computing@jaws-users.com> Sent: Saturday, January 26, 2008 2:11 PM Subject: [Blind-Computing] Using COUNT or COUNTA in Excel > 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/blind-computing@jaws-users.com/ > To post to this group, send email to > blind-computing@jaws-users.com > 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] > Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/blind-computing@jaws-users.com/ To post to this group, send email to blind-computing@jaws-users.com 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]
