No I don't think this is what she is trying to do. She is trying to count the number of time "open " appears as a value in a cell range, and then go on to calculate the frequency of other values also. . I have done this sort of thing before some years ago and I am trying to root out an old spreadsheet to see if I can remember how I did it.
One thing is that I never used a counta function, always a count function but I do not know if this makes any difference The other thing I would try eliminating in the formula is the space between the range and the value statement. If I can find a functioning count formula I will paste it into a message here. Regards David Griffith -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacob Kruger Sent: Sunday, 27 January 2008 14:25 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]
