Average Array help with a formula

  • Thread starter chedd via OfficeKB.com
  • Start date
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 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
 
D

Domenic

Let's assume that Column L may contain 'Attended', try...

=AVERAGE(IF($K$15:$K$75="Alc & M
Health",IF($L$15:$L$75="Attended",$N$15:$N$75)))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
C

chedd via OfficeKB.com

Thank you for your help and the formula worked a treat.
Let's assume that Column L may contain 'Attended', try...

=AVERAGE(IF($K$15:$K$75="Alc & M
Health",IF($L$15:$L$75="Attended",$N$15:$N$75)))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
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
Click to expand...
[quoted text clipped - 7 lines]
Chris Bennett
Click to expand...
Click to expand...
 
Top