average 150
 

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
--
oldLearner57

average 150
 

Are you trying to enter an array formula?

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

Dave
--
Brevity is the soul of wit.


"tikchye_oldLearner57" wrote:

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
--
oldLearner57

average 150
 

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

u have a nice day :)
--
oldLearner57


"Dave F" wrote:

Are you trying to enter an array formula?

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

Dave
--
Brevity is the soul of wit.


"tikchye_oldLearner57" wrote:

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
--
oldLearner57