average array formulae return different results

Hi,

Please can you help me understand why this formula is not working i.e. it is returning zero?

=AVERAGE(IF(AND(Pension!$F$5:$F$52<=20000,Pension!$F$5:$F$52<=20000),Pension!$L$5:$L$52)) entered with ctrl+shift+enter

This version without the AND statement works fine:

=AVERAGE(IF(Pension!$F$5:$F$52<=20000,Pension!$L$5:$L$52)) entered with ctrl+shift+enter

Thanks

Andrew

I assume it returning value of L5.
Is 0 in L5?

Please use code tag because unable to view your full formula.

I hope there is no use or logic in using the same condition twice (In the below formula)

Formula:

Please Login or Register  to view this content.

Originally Posted by penfold

Sorry, the formula I am trying to get to work is here:

Formula:

Please Login or Register  to view this content.

Thanks

Andrew

* works as AND with array formula

Please check the below Untested formula

Formula:

Please Login or Register  to view this content.

Hope that helps!