| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
