This is probably easy, but I don’t know how to do it. I have a spreadsheet that lists the sales from my little bookstore. I have a field to keep track of where they sell (Alibris, Amazon, eBay, etc.). How do I filter by that field and show an average of what the books sell for in each venue?

Field 1: sale price

Field 2: fees

Field 3: postage charged

Field 4: postage spent

Field 5: cost

Field 6: net (calculated: 1 -2 +3 -4 -5)

Field 7: venue

I want to show the average of Field 6 for each value in Field 7.

MicroSoft Excel 2007