i need to figure the average of some items. Here is the tricky part. I only
need to get the average for some of the items, based on type. for example..if
in column B i have items listed as book tire and car...i only want to get the
average of the books. i know i can get the total number of items and the sum
of the specific items, but i can't seem to get the average of them.



so for example the following in colums B C and D respectively how would i
go about getting the average prices for each if there were multiples of each
type of gear.

merchandise gear amount
ear muffs gear $290.98
team picture souvenirs $56.98
xl gym shorts Apparel $35.98
Glass Beer Mug Souvenirs $24.95
M t-shirt Apparel $19.99