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

 

[adam087]

Is the 'H' the filter applied?
If so you can use =COUNTIF(B:B, "H") to count the number of rows irrespective of the filter. (Change B:B to be your chosen column, and it'll be faster if you use the exact range not the full column).

Adam

 

[Spraggs]

The filter is on columns E and H is in column O ?

 

[Dannyh1]

Hi

what are you filtering in column E?

e.g if you are filtering A in column E, try:

=SUMPRODUCT((E1:E100="A")*(O1:O100="H"))

 

[Spraggs]

Column E is a list of areas, hence when filtered doesn't show all rows.
Once filtered I want to count the remaining cells in column O that contains H

 

[Matt Rogers]

Hi.

Check this:

Excel Workbook
	A	B
1	Hawaii	3
2	Honolulu
3	Alaska
4	Hotel
5	China
6
Sheet

 

[Spraggs]

Don't think I'm explaining very well....
I have a spreadsheet A1:O3389
Any column from A:N can be filtered
In column O (O2:O3389) is entered either "L" "H" or "P"
When one of the columns (or multiple) are filtered I want to count how many "H"s are left in column O.

Hope this is clearer.

 

[Dannyh1]

I found old post from Aladin Akyurek:

Try this:

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

 

[Spraggs]

Danny, thanks for your time. This is returning TRUE and not a number. This all seems over complicated for what I'm after, is it not?

 

[Spraggs]

This works..

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