Ignore Filtered Out Data in a Formula

How do I best get the LINEST and INTERCEPT formulas to ignore data that I have filtered out?

I have a table that has multiple data samples that meet each of my criteria for sorting, and I would like to see how the data trends change when I filter out some of the data points. Interestingly enough, I have noticed that the scatter graph that I have on the sheet updates itself with only the visible data, as does the trendline equation on the chart. I want that equation to update with my filterings on the sheet as well. Any help would be greatly appreciated.

I'm assuming that by all the silence on this issue that it may not be possible. How about a macro that can take the line equation and R2 value from the graph of the data?