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.

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.