| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate average with missing values
Hi! In column A I have values in some cells and "#MISSING!" in some cells.
In column B I want to calculate the average value of e.g. A1 to A3. How can I do that when some values are missing? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I calculate the average of a list of time values in excel | Excel Worksheet Functions | |||
| ignore MAX and MIN values in a set to calculate average | Excel Discussion (Misc queries) | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| Calculate average and not include zero values | Excel Discussion (Misc queries) | |||
| Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
Threaded Mode
