If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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
|
|||
|
|||
#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
|
|||
|
|||
#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 |
Thread Tools | |
Display Modes | |
|
|