| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if is error then "No Data", if not then average range
I believe the formula should be something like:
iferror(average(C1:F1=TRUE,"No Data), average(C1:F1) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if is error then "No Data", if not then average range
=IFERROR(AVERAGE(C1:F1),"No Data")
"SK08" wrote: I believe the formula should be something like: iferror(average(C1:F1=TRUE,"No Data), average(C1:F1) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "num#" errors .. how to average a group with a "num#" error | Excel Discussion (Misc queries) | |||
| "Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
| Formula to figure an average on a range of cells with an "if" form | Excel Worksheet Functions | |||
| Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Linear Mode
