If you need further help, Add a sample workbook. We can help if we know what your data looks like.
But here are some steps that I think will work!
1) Create your view:
2) add Totals, and use average:
Now you can add your filters, and let the totals do the work for you. Is that what you wanted to achieve? If not, I'll be happy to help with more explanation/details!
Thank you, both. I went with Deepak's response. It was closer to what I already had, I just didn't have the calculation correct.
Great it Worked for you!!!