Counting Cells

[silvertabb]

Hi
how do you count a specific answer in a colum (e.g. Yes, No, UKN)? When I filter YES and use the COUNT formula, the output includes the visible YES and non visible NO/UKN options.

 

[mtskv5]

=countif(a:a,"yes")

 

[Aladin Akyurek]

Hi
how do you count a specific answer in a colum (e.g. Yes, No, UKN)? When I filter YES and use the COUNT formula, the output includes the visible YES and non visible NO/UKN options.

Try...

=SUBTOTAL(3,Range)

Is this what you need?