| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with DIV/0 error in an AVERAGE array formula
I am using =AVERAGE(IF(isnumber(0(C3:C8)),0(C3:C8,"")) to calculate an
average % in a column with zero's and Excel is giving me a message that the formula is incorrect. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula - Average from every other cell | Excel Discussion (Misc queries) | |||
| Average If Array Formula | Excel Worksheet Functions | |||
| Average Array help with a formula | Excel Worksheet Functions | |||
| Array Formula to Pick Average | Excel Discussion (Misc queries) | |||
| Average Array Formula | Excel Worksheet Functions | |||
Threaded Mode
