average >150

[tikchye_oldLearner57]

hi community

can someone kindly assist me why I got answer as #value (could be wrong
function use ??) but I am "blind"....

I want to average the cells in col A that are >150
A B
1 200
2 205 150
3 150
4 75

my formula is =average(if(a1:a4)>b2,a1:a4) and i pressed ctrl+Enter but i
got #VALUE as output

can somebody help me

thanks to all

 

[Dave F]

Are you trying to enter an array formula?

If you are, you need to press CTRL+SHIFT+ENTER.

Dave

 

[tikchye_oldLearner57]

yes! is an array and i miss the "shift" key.......
thanks Dave F !

u have a nice day