Problem with AVERAGE(IF

[Alby]

Hi

Don kindly helped me out with this problem earlier.

I have another problem!

{=AVERAGE(IF(B6:B150="North",E6:E150))} result is 73

but
If I use this formula on a different spreadsheet:

{=AVERAGE(IF('Load times'!
$B$6:$B$150="North",$E$6:$E$150))}
the result is 16

What am I missing?

Thanks
Alby

 

[Frank Kabel]

Hi
maybe:
=AVERAGE(IF('Load times'!$B$6:$B$150="North",'Load times'!$E$6:$E$150))
entered as array formula
Frank

 

[Alby]

Perfect! thanks Frank

-----Original Message-----
Hi
maybe:
=AVERAGE(IF('Load times'!$B$6:$B$150="North",'Load times'!$E$6:$E$150))
entered as array formula
Frank



.