I have built a model that is linked to a sheet of data. What I would like to do is let someone filter the data, say by state and then have the model change from showing all results to just those filtered results. The tricky part is that I need to use the countif and sumif functions to tell the resulting data where to go in the model. So, for example, I have a bunch of data in column D. The data could get filtered by columns A- C. The model then says, count the data points in column D if column I is "31." I have tried some of the suggestions offered, but I'm doing something wrong. I would be grateful for any suggestions.