Help with formula

[flymeoutofhere]

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.

 

[Ragdyer]

One way:

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

 

[ShaneDevenshire]

Hi,

If you are using 2007 then

=AVERAGEIF(B1:B10,"Toyota Corolla",E1:E10)

or better, type Toyota Corolla into A1 and use

=AVERAGEIF(B1:B10,A1,E1:E10)

In earlier versions you can use the following Array Entered formula:

=AVERAGE(IF(B1:B10="Toyota Corolla",E1:E10,""))

Array entry means you press Shift+Ctrl+Enter to enter the formula not Enter.