| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
AVERAGE excluding #N/A
I have read through most of posts that seem to apply but haven't found a
formula that will allow me to calculate the AVERAGE, MAX and MIN for a data range that also contains #N/A in several cells. Can you help? -- RonB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using The Average Function if a cell has NA | Excel Worksheet Functions | |||
| AVERAGE problems | Excel Worksheet Functions | |||
| EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
| calculate average hours worked | Excel Worksheet Functions | |||
| average, array and offsets | Excel Worksheet Functions | |||
Threaded Mode
