| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Averages
Is there a formula by which when I have say e.g. four entries in a column
on lines 31,32,33 & 34 I can obtain a average of these entries in line 35? If there is how do I arrange matters so that if I add entries above line 35 this line will automatically adjust itself to show a new average? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Averages
try =SUM(A31:A99)/COUNTA(A31:A99) This formula is using data in column A and allows you to fill in values between rows 31 and 99 without needing to change theformula hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=552892 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Averages
Many thanks for the reply. I am affraid that this formula did not produce
the result for me. I have these entries in line 31-34 Col. G:- 40.66 35.97 38.86 38.88 the average should be 38.59, but with the formula:- =Sum (G31-G99)/COUNTA (G31-G99) I am getting 40.66 - the first entry. Where did I go wrong? "tony h" wrote in message ... try =SUM(A31:A99)/COUNTA(A31:A99) This formula is using data in column A and allows you to fill in values between rows 31 and 99 without needing to change theformula hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=552892 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Averages
Might be a type-o somewheres..........it appears to work fine for me,
returning 38.5925 with your given data/location Vaya con Dios, Chuck, CABGx3 "Zygy" wrote in message ... Many thanks for the reply. I am affraid that this formula did not produce the result for me. I have these entries in line 31-34 Col. G:- 40.66 35.97 38.86 38.88 the average should be 38.59, but with the formula:- =Sum (G31-G99)/COUNTA (G31-G99) I am getting 40.66 - the first entry. Where did I go wrong? "tony h" wrote in message ... try =SUM(A31:A99)/COUNTA(A31:A99) This formula is using data in column A and allows you to fill in values between rows 31 and 99 without needing to change theformula hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=552892 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Averages
Replace your minus signs,
=SUM(G31-G99)/COUNTA(G31-G99) with colons: =SUM(G31:G99)/COUNTA(G31:G99) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Zygy" wrote in message ... Many thanks for the reply. I am affraid that this formula did not produce the result for me. I have these entries in line 31-34 Col. G:- 40.66 35.97 38.86 38.88 the average should be 38.59, but with the formula:- =Sum (G31-G99)/COUNTA (G31-G99) I am getting 40.66 - the first entry. Where did I go wrong? "tony h" wrote in message ... try =SUM(A31:A99)/COUNTA(A31:A99) This formula is using data in column A and allows you to fill in values between rows 31 and 99 without needing to change theformula hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=552892 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Averages
Thank you all for the contributions. Unfortunately I still cannot get the
right answer.When I use the semicolon instead of the minus I get a notice stating that I made a mistake and will I accept the correction to the Formula made by Excel, which is exactly the same as the one I typed in. When I click OK I get another notice stating that Excel cannot carry out the calculation, because I created a "Circular Reference"! My OS is Win.XPPro (SP2) and Office Pro 2003. Any further suggestions will be gratefully received. "RagDyeR" wrote in message ... Replace your minus signs, =SUM(G31-G99)/COUNTA(G31-G99) with colons: =SUM(G31:G99)/COUNTA(G31:G99) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Zygy" wrote in message ... Many thanks for the reply. I am affraid that this formula did not produce the result for me. I have these entries in line 31-34 Col. G:- 40.66 35.97 38.86 38.88 the average should be 38.59, but with the formula:- =Sum (G31-G99)/COUNTA (G31-G99) I am getting 40.66 - the first entry. Where did I go wrong? "tony h" wrote in message ... try =SUM(A31:A99)/COUNTA(A31:A99) This formula is using data in column A and allows you to fill in values between rows 31 and 99 without needing to change theformula hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=552892 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Averages
Zygy
Use colons, not semi-colons! Do not place the formula in any cell referenced within the formula! Try putting =SUM(G31:G99)/COUNTA(G31:G99) in H34 Does this help? George Gee "Zygy" wrote in message ... Thank you all for the contributions. Unfortunately I still cannot get the right answer.When I use the semicolon instead of the minus I get a notice stating that I made a mistake and will I accept the correction to the Formula made by Excel, which is exactly the same as the one I typed in. When I click OK I get another notice stating that Excel cannot carry out the calculation, because I created a "Circular Reference"! My OS is Win.XPPro (SP2) and Office Pro 2003. Any further suggestions will be gratefully received. "RagDyeR" wrote in message ... Replace your minus signs, =SUM(G31-G99)/COUNTA(G31-G99) with colons: =SUM(G31:G99)/COUNTA(G31:G99) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Zygy" wrote in message ... Many thanks for the reply. I am affraid that this formula did not produce the result for me. I have these entries in line 31-34 Col. G:- 40.66 35.97 38.86 38.88 the average should be 38.59, but with the formula:- =Sum (G31-G99)/COUNTA (G31-G99) I am getting 40.66 - the first entry. Where did I go wrong? "tony h" wrote in message ... try =SUM(A31:A99)/COUNTA(A31:A99) This formula is using data in column A and allows you to fill in values between rows 31 and 99 without needing to change theformula hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=552892 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating weighted averages | Excel Discussion (Misc queries) | |||
| averages in pivot tables | Excel Discussion (Misc queries) | |||
| Function for generating monthly & weekly averages | Excel Worksheet Functions | |||
| Trouble Sorting Averages of Randomly Generated Numbers | Excel Discussion (Misc queries) | |||
| calculating averages | Excel Discussion (Misc queries) | |||
Hybrid Mode
