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?