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