Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling average | Excel Worksheet Functions | |||
Modified Average Function | Excel Worksheet Functions | |||
in a pivot table, can the average include blank entries? | Excel Discussion (Misc queries) | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions |