Fair enough. Glad you came right.
Stay well Jacob Kruger Blind Biker Skype: BlindZA '...Fate had broken his body, but not his spirit...' ----- Original Message ----- From: "Annette" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, January 27, 2008 6:08 PM Subject: Re: [Blind-Computing] Using COUNT or COUNTA in Excel > 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: [email protected] > 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: <[email protected]> > 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/[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] >> > > > 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] > > > 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] > 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]
