| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Average function not returning expected result
Hi all:
I have a column of 25 numbers that include zeros that total 74. I have applied the average function and rounded the result to two decimal places. ROUND(AVERAGE (number 1,number 2...),2). The result that I am receiving from excel is 2.64. When I use a calculator the result is 2.96. What am I doing wrong? -- Thanks, Greg |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Average function not returning expected result
It sounds to me as if some of your data may actually be text. If you use
SUM(your range) do you really get 74? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "gja63" wrote in message ... Hi all: I have a column of 25 numbers that include zeros that total 74. I have applied the average function and rounded the result to two decimal places. ROUND(AVERAGE (number 1,number 2...),2). The result that I am receiving from excel is 2.64. When I use a calculator the result is 2.96. What am I doing wrong? -- Thanks, Greg |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Average function not returning expected result
Please don't multipost. Cross-post if you must.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph "gja63" wrote in message ... Hi all: I have a column of 25 numbers that include zeros that total 74. I have applied the average function and rounded the result to two decimal places. ROUND(AVERAGE (number 1,number 2...),2). The result that I am receiving from excel is 2.64. When I use a calculator the result is 2.96. What am I doing wrong? -- Thanks, Greg |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Average function not returning expected result
Do any of these help?
=AVERAGE(IF(A1:A12<0,A1:A12,FALSE)) =AVERAGE(IF(A1:A50,A1:A5)) =SUM(A1:A12)/COUNTIF(A1:A12,"0") =SUM(A1:A5)/COUNTIF(A1:A5,"<0") Adjust ranges to suit your needs........... -- RyGuy "gja63" wrote: Hi all: I have a column of 25 numbers that include zeros that total 74. I have applied the average function and rounded the result to two decimal places. ROUND(AVERAGE (number 1,number 2...),2). The result that I am receiving from excel is 2.64. When I use a calculator the result is 2.96. What am I doing wrong? -- Thanks, Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average function not returning expected result | Excel Discussion (Misc queries) | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| IF function returning incorrect result | Excel Worksheet Functions | |||
| Using sum(1/countif....) not returning expected result | Excel Worksheet Functions | |||
| LOOKUP function not returning expected value - Using vector_lookup format | Excel Worksheet Functions | |||
Linear Mode
