| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I average a range of cells when one cell contains #N/A
I perform a lookup where the results could populate one cell or as many as 15
cells with number results. The cells that do not result in numbers have #N/A. I want to average the fifteen cells but only the cells with numbers. How do I get it to ignore the #N/A when performing the average? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| monitoring a changing range of cells | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Threaded Mode
