Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm using Excel 2002 within Office XP for Small Business ver 2002. I want to
calculate the average excluding zero values. I have used the following formula: =AVERAGE(IF(Q5:Q35<0,Q5:Q35,"")) This is correct according to the help function and is also correct on a later version of small business. Any ideas what I'm doing wrong? thx. |
#2
![]() |
|||
|
|||
![]()
Hi
have you entered this formula as array formula (entered with CTRL+SHIFT+ENTER)? -- Regards Frank Kabel Frankfurt, Germany "Danny" schrieb im Newsbeitrag ... I'm using Excel 2002 within Office XP for Small Business ver 2002. I want to calculate the average excluding zero values. I have used the following formula: =AVERAGE(IF(Q5:Q35<0,Q5:Q35,"")) This is correct according to the help function and is also correct on a later version of small business. Any ideas what I'm doing wrong? thx. |
#3
![]() |
|||
|
|||
![]()
Thanks Frank ... that's what I forgot.
"Frank Kabel" wrote: Hi have you entered this formula as array formula (entered with CTRL+SHIFT+ENTER)? -- Regards Frank Kabel Frankfurt, Germany "Danny" schrieb im Newsbeitrag ... I'm using Excel 2002 within Office XP for Small Business ver 2002. I want to calculate the average excluding zero values. I have used the following formula: =AVERAGE(IF(Q5:Q35<0,Q5:Q35,"")) This is correct according to the help function and is also correct on a later version of small business. Any ideas what I'm doing wrong? thx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Using Average function when number is zero | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions |