Hello,

I have a table which I often use the filter.
I have a COUNTIF formula
Formula: copy to clipboard
=COUNTIF(E2:E17,"Apple")
counting the amount of time a specific word is listed in the table. Lets say theres currently 5 "Apples" listed so my COUNTIF formula displays 5.

i want the COUNTIF formula to work based on how many are displayed. so if i use the filter and only 2 "Apples" are on display, I would like my COUNTIF formula to show 2.

Thanks