| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average function with If
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
