=AVERAGE(IF(C2:C100="Souvenirs",D2:D100))
ctrl+shift+enter, not just enter

For XL2007
=AVERAGEIF(C2:C100,"Souvenirs",D2:D100)
just enter


"Eelinla" wrote:

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