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