| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using The Average Function if a cell has NA
I have a formula in Col A,B,C,D that sometimes returns #N/A. I would like to
average the numbers in Col E but the average function returns #N/A. Is there a way to use the average function to exclude the NA's ? Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| Using the MAX function with "constant increment" cell references | Excel Worksheet Functions | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Threaded Mode
