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

Average Array help with a formula
 

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!

In article <5b230baefa31a@uwe, "chedd via OfficeKB.com" <u18187@uwe
wrote:

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

Average Array help with a formula
 

Thank you for your help and the formula worked a treat.

Domenic wrote:
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

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