MissConfussed,

Welcome to the forum!
What you need are the ...if() function.
To count how many [item], use the Countif() function
To sum the price of [item], use the Sumif() function
To average the price of [item], you'll need to do Sumif()/Countif(), that is the Sumif() function divided by the Countif() function.