C
chedd via OfficeKB.com
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 i need
to add to this formula to the adverage. =AVERAGE(IF($K$15:$K$75="Alc & M
Health",$N$15:$N$75)).
I appreciate your help.
Chris Bennett
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 i need
to add to this formula to the adverage. =AVERAGE(IF($K$15:$K$75="Alc & M
Health",$N$15:$N$75)).
I appreciate your help.
Chris Bennett