wow, thx Mike! it works!

do you know if i can put "A=3" instead of just the total count?

brie

"Mike H" wrote:

Try,

=COUNTIF(A1:A100,"A")

The "A" could be a cell reference where that cell contains what you are
trying to count.

=COUNTIF(A1:A100,B1)

Mike

"Brie" wrote:

i want to filter and count the data in 1 column

4 eg. i have 3 different data, i.e. A, B and C.

Total A+B+C = 10 entries.

A=3 entries, B=4, C=4.

how to generate this data using formula or filter?

many thx.

brie