| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average cells, show 0 if nothing to average
I am averaging the following:
=AVERAGE(G67:G76), this works fine (simple formula). However, if nothing is entered in all of these cells, I would like my results cell to display 0. Currently if nothing is entered for G67 thru G76, it results in #DIV/0!. I just want it to show 0. I know this is simple, but I am dancing all around it. Any suggestions would be appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average price of 4 columns of figures but some cells can be blank | Excel Worksheet Functions | |||
| average price of 4 columns of figures but some cells can be blank | Excel Worksheet Functions | |||
| How to find the Average of cells containing a value | Excel Discussion (Misc queries) | |||
| Another Average non-adjacent cells question... | Excel Discussion (Misc queries) | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Threaded Mode
