Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|