Count filtered column

[Spraggs]

How do I count the number of times the letter "H" appears in a column when the column is filtered?
Thank you

 

[Aladin Akyurek]

This works..

=SUMPRODUCT(SUBTOTAL(3,OFFSET(O2:O3389,ROW(O2:O3389)-ROW(O2),0,1)),--(O2:O3389="H"))

The older form should also work, that is, return a number. Knowing that ROW(O2) --> {2} is processible because SumProduct operates on arrays has led me to drop MIN from this type of formula expression (crafted by Longre originally). It can be even written as:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(O2,ROW(O2:O3389)-ROW(O2),0,1)),--(O2:O3389="H"))

Note that the never expression is also set up in SumProduct's native comma syntax.