Help with formula
 

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.

Help with formula
 

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.

Help with formula
 

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.


--
Thanks,
Shane Devenshire


"flymeoutofhere" wrote:

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.