Average Array help with a formula

[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

 

[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!

 

[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

[quoted text clipped - 7 lines]

Chris Bennett