One way:

=Sumif(B:B,"Toyota Corolla",E:E)/Countif(B:B,"Toyota Corolla")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"flymeoutofhere" wrote in message
...
Hi there

I have been trying for ages to figure out what is probably a really simple
forumla...

I have a spreadsheet listing cars for sale. I have, for example, 15
records
for toyota corolla. I want to average the prices of these automatically.
The
text Toyota Corolla is in column B and the price in column E

I hope this is possible and easy.

Thanks in advance.