Hi,
I am working on a formula and I need the range to change when a filter is added. I can not use subtotal because it has conditionals. Here is the current formula I have but I need it to also work when an auto filter is selected.

=COUNTIF(Scores!$BP:$BP,">26")&" "&"Applications"

Thanks in advance