Count of filtered items

Originally Posted by EnglishDeath

I Have a column of data. I apply Data Filter. And I hace a countif >0 funtion in A1. When I apply filter by selection the count still counts the entire column not the filtered items.

Any ideas how I can count the filter?

=SUBTOTAL(3,A:A)

note, that counts filtered non-blank items, not 'countif >0'

added

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C1:C15,ROW(C1:C15)-0,,1)),--(C1:C15>0))

counts C1:C15 filtered >0

---