Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    2

    Unanswered: hot to count the text values

    i have problem using excel....
    i have column in excel as given below...

    a
    a
    b
    c
    a
    a
    b
    c
    b
    a
    a


    how to sum up the number of times "a" appear in this column...answer should come 6 n 3 for "b" ans 2 for "c"

  2. #2
    Join Date
    Jun 2006
    Posts
    103
    Quote Originally Posted by faryal
    i have problem using excel....
    i have column in excel as given below...

    a
    a
    b
    c
    a
    a
    b
    c
    b
    a
    a


    how to sum up the number of times "a" appear in this column...answer should come 6 n 3 for "b" ans 2 for "c"
    i attached a copy of the excel sheet which will count the number of occurance for a,b,c by a click of the button, put the input on column A in sheet1, as many row as u want, but must be continuous. Try it out, and u will get the picture.
    Attached Files Attached Files

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    No need for code.

    Put "a" (without quotes) in cell C1. Then in D1 put this formula:

    =COUNTIF(A:A,"a")

    Add "b" in C2, and "c" in C3, then copy the formula above down.
    Last edited by shades; 07-17-06 at 10:55.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •