| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I average a group of cells and ignore a #div/0! error?
Him You Them Us Me
12 10 8 6 12 11 7 4 11 9 6 9 average 11.6 10 7 6.3 #DIV/0! How can you average the cells in the bottom row and ignore the #div/0! Error to get the answer 8.76? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zero value cells/blank cells causing error in AVERAGE? | Excel Worksheet Functions | |||
| average with out rounding up in a group of cells | Excel Worksheet Functions | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| How do I ignore cells with errors when calculating an average? | Excel Worksheet Functions | |||
| calculate average in percentage coloumn with #DIV/! (ignore error | Excel Discussion (Misc queries) | |||
![Scott R[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
