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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate average with missing values
This will still give you the average of the cells which contain
numbers: =AVERAGE(A1:A3) For example, A1 = 1, A2 = "text", A3 = 2 gives B1 = 1.5. Hope this helps. Pete On Jan 14, 9:46*am, Arne Hegefors wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate average with missing values
One way:
=AVERAGE(A1:A3) AVERAGE() ignores text. If you may not have ANY numeric values in A1:A3, then perhaps: =IF(COUNT(A1:A3),AVERAGE(A1:A3),"No Values") In article , Arne Hegefors wrote: 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! |
Reply |
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 |