Thanks for your response. That is not quite what I am trying to accomplish. I found another function that did the job. If is the COUNTIF function and it looks like this:
=countif(g5:g54,"completed") This will look in the range g5 through g54 for the word "completed" and add up the number of time the words appears in the range. An example of how you might want to use this function is as follows. If you had a list of names of people and the name of their favorite food and you wanted to know how many people selected each type of food. For each of the different foods listed in that column, you would write the above formula with the name of one of the foods inside of the quotes instead of the word completed as I needed. The result in the cell where you placed this formula would be the total number of people who selected that food as their favorite. Annette -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacob Kruger Sent: Sunday, January 27, 2008 9:25 AM To: blind-computing@jaws-users.com Subject: Re: [Blind-Computing] Using COUNT or COUNTA in Excel 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] 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]
