View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tam25 tam25 is offline
external usenet poster
 
Posts: 10
Default exluding missing data values from equation

We are required to specify why data is missing and we have therefore given it
a number value (eg 999 for missing, 777 for not applicable). However we need
to be able to exclude these values from the final calculation in order to get
the correct answer. What can we do???