Array with Average & Min

[maheshmaxi]

Hi,

I tried to use array with Average, Min & Max formulas. But only 'Max' works, others do not. Below are my attempts. Can anyone help me achieving results for other two functions or in any alternative ways...

{=AVERAGE(IF(L31:L53="Arvind",O31:O53,0))} -- Did not give correct output (wrong result)
{=MIN(IF(L31:L53="Arvind",O31:O53,0))} -- Not working (result=0)
{=MAX(IF(L31:L53="Arvind",O31:O53,0))} -- Working

 

[Comfy]

For average if you could use:

=SUMIF(L31:L53,"=Arvind",O31:O53)/COUNTIF(L31:L53,"=Arvind")

 

[Comfy]

Here's one that will return the minimum

=MIN(IF(L31:L35="Arvind",IF(O31:O35<>"",O31:O35)))