View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chedd via OfficeKB.com
 
Posts: n/a
Default Average Array help with a formula

Can any one help in this array formula. I need to find the average days in
column N selecting Alc & M Health in column K. This formula is working
giving me the average days for Alc & M Health. However I need to from
another column associate Attended against Alc & M Health and Column N to
find the average for those attended. Please can you tell me to what Ineed
to add to this formula to find the average. =AVERAGE(IF($K$15:$K$75="Alc & M
Health",$N$15:$N$75)).

I appreciate your help.

Chris Bennett

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200601/1