#missing!

  • Thread starter Thread starter Arne Hegefors
  • Start date Start date
A

Arne Hegefors

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
 
=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.
 
In Swedish that would be


=MEDEL(OM(ÄRTAL(A1:A100);A1:A100;""))

still entered with ctrl + shift & enter



--


Regards,


Peo Sjoblom
 
Back
Top