How to mix Subtotal & Countif

[nghiencuukh7]

Hello everybody ! Have a good day
Today i want to ask you how can i mix Subtotal & countif
Because i want to count all the code in the table but it is Text , i used =COUNTIF(B3:B1858,"*") and it count all text but when i choose fillter some code. The number in countif cell does not change
Here is my exel file https://www.dropbox.com/s/lwy8rlaosc8id2p

 

[sandy666]

maybe try

=SUBTOTAL(103,B3:B993)

 

[nghiencuukh7]

thank you.
So what is different between 103 and 3 :D

 

[Taul]

From the help file:-
1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.

 

[nghiencuukh7]

From the help file:-
1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.

So from my help file. Could you show me how to detect the hidden rown in cell before i handlding, and what should i do :D

 

[Taul]

Your file has hidden columns (C, D & E) but no hidden rows.
Therefore you should use the formula posted by sandy666