| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i get an average with #div/0! in a cell
I am looking to get an average from like c9:l9. Those cells are linked to
other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| eliminating the 0 in DIV/0 | Excel Discussion (Misc queries) | |||
| average every 6th cell in a column | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
