| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#DIV/0 ERROR in AVERAGING
I am creating a worksheet for 2005 calendar year that shows averages.
AVERAGE(C6:AG6) However, when I the cells are empty the #div/0! displays. I have been trying to do the IF Function to display a 0 if there is nothing to Average. Any help is greatly appreciated. Thanks, Patty R. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
| "Average" with error DIV/0 | Excel Discussion (Misc queries) | |||
| Averaging function | Excel Discussion (Misc queries) | |||
| Averaging the last 5 entries in a row | Excel Discussion (Misc queries) | |||
| Averaging cells which contain #DIV/0! | Excel Worksheet Functions | |||
Threaded Mode
