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
|