Array?
 

Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and Column E has a
value in it, then give me the average of E.

A blank is returned. Please advise.


=IF(AND($F$2:$F$34="Medium",$E$2:$E$34""),AVERAGE ($E$2:$E$34),"")

Array?
 

try this

=AVERAGE(IF(F5:F16="medium",E5:E16,"")) ( use ctrl + shift + enter )


On Oct 24, 7:56*pm, PAL wrote:
Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and *Column E has a
value in it, then give me the average of E.

A blank is returned. *Please advise.

=IF(AND($F$2:$F$34="Medium",$E$2:$E$34""),AVERAGE ($E$2:$E$34),"")

Array?
 

Try this array formula:
=AVERAGE(IF($F$2:$F$34="Medium",IF($E$2:$E$34<"", $E$2:$E$34,""),""))

--
** John C **

"PAL" wrote:

Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and Column E has a
value in it, then give me the average of E.

A blank is returned. Please advise.


=IF(AND($F$2:$F$34="Medium",$E$2:$E$34""),AVERAGE ($E$2:$E$34),"")

Array?
 

This will give you an error #DIV/0 if there are no values next to a Medium :)
--
** John C **

"John C" wrote:

Try this array formula:
=AVERAGE(IF($F$2:$F$34="Medium",IF($E$2:$E$34<"", $E$2:$E$34,""),""))

--
** John C **

"PAL" wrote:

Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and Column E has a
value in it, then give me the average of E.

A blank is returned. Please advise.


=IF(AND($F$2:$F$34="Medium",$E$2:$E$34""),AVERAGE ($E$2:$E$34),"")

Array?
 

This works. Thanks. If I change average to Count, it doesn't. Thoughts?

"John C" wrote:

Try this array formula:
=AVERAGE(IF($F$2:$F$34="Medium",IF($E$2:$E$34<"", $E$2:$E$34,""),""))

--
** John C **

"PAL" wrote:

Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and Column E has a
value in it, then give me the average of E.

A blank is returned. Please advise.


=IF(AND($F$2:$F$34="Medium",$E$2:$E$34""),AVERAGE ($E$2:$E$34),"")

Array?
 

COUNT works for me, what are you getting? What do you expect to get?
--
** John C **

"PAL" wrote:

This works. Thanks. If I change average to Count, it doesn't. Thoughts?

"John C" wrote:

Try this array formula:
=AVERAGE(IF($F$2:$F$34="Medium",IF($E$2:$E$34<"", $E$2:$E$34,""),""))

--
** John C **

"PAL" wrote:

Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and Column E has a
value in it, then give me the average of E.

A blank is returned. Please advise.


=IF(AND($F$2:$F$34="Medium",$E$2:$E$34""),AVERAGE ($E$2:$E$34),"")

Array?
 

Got it, not sure what I did the first time. thanks.

"John C" wrote:

COUNT works for me, what are you getting? What do you expect to get?
--
** John C **

"PAL" wrote:

This works. Thanks. If I change average to Count, it doesn't. Thoughts?

"John C" wrote:

Try this array formula:
=AVERAGE(IF($F$2:$F$34="Medium",IF($E$2:$E$34<"", $E$2:$E$34,""),""))

--
** John C **

"PAL" wrote:

Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and Column E has a
value in it, then give me the average of E.

A blank is returned. Please advise.


=IF(AND($F$2:$F$34="Medium",$E$2:$E$34""),AVERAGE ($E$2:$E$34),"")