Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#missing!
Hi! I have a worksheet with several tables. The tables are linked to each
other using functions such as LOOKFORROW and others. I want to calculate the average of certain columns. however in many columns there is one or more cells that says #MISSING!, hence I cannot calculate an average. How do I solve this? I want simply ignore the missing values or treat them as the value befor or something. thanks alot for any help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#missing!
=AVERAGE(IF(ISNUMBER(A1:A100),A1:A100,""))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200807 "Arne Hegefors" wrote: Hi! I have a worksheet with several tables. The tables are linked to each other using functions such as LOOKFORROW and others. I want to calculate the average of certain columns. however in many columns there is one or more cells that says #MISSING!, hence I cannot calculate an average. How do I solve this? I want simply ignore the missing values or treat them as the value befor or something. thanks alot for any help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#missing!
In Swedish that would be
=MEDEL(OM(ÄRTAL(A1:A100);A1:A100;"")) still entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Gary''s Student" wrote in message ... =AVERAGE(IF(ISNUMBER(A1:A100),A1:A100,"")) This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200807 "Arne Hegefors" wrote: Hi! I have a worksheet with several tables. The tables are linked to each other using functions such as LOOKFORROW and others. I want to calculate the average of certain columns. however in many columns there is one or more cells that says #MISSING!, hence I cannot calculate an average. How do I solve this? I want simply ignore the missing values or treat them as the value befor or something. thanks alot for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#Missing | Excel Worksheet Functions | |||
Something Missing | Excel Worksheet Functions | |||
Who is missing ? | Excel Discussion (Misc queries) | |||
Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
Missing Row | Excel Worksheet Functions |