I'm not even sure how to explain it, so I've uploaded the file. Under the test tab, on row two, it currently averages the rows below based on a lookup. Now if I add a filter to the headings, how can I have this formula only average for the ones showing? Not sure it's even possible.Support Customer Satisfaction Report 2013 Test.xlsx

Any suggestions would be great.