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.
|