I have a formula that EE Pros just helped me properly adjust. It does a great job..... but here is my question. I want to put a filter on each column then depending on what I filter, I want the formulas to change. (I'm using the formulas to construct a Dashboard and I do not want to use a pivot table. So when I filter on a column, how do I get it to only count those variables which are showing?
Thank you in advance..... and here is the original formula:
=countifs(j1:j115,"Sales Rep", B11:B115,"Yes").