it's okay Mike.

i've tricked it by writing down the cell reference, in this case "A", in one
column and put the countif in another column.

it's quite adequate for my purpose anyway.

you've been a big help afterall.

brie

"Mike H" wrote:

Hi,

No you cant do that in the way you think because "a=3" is a string of
characters and the formula would look for that literal string in the range of
cells.

If you post exactly what you are trying to do in evaluating the value of A
then I'm sure someone can help.

Mike

"Brie" wrote:

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