AVERAGE(IF()) problem
Hi!
That is an array formula and MUST be entered using the key combo of
CTRL,SHIFT,ENTER.
If done properly Excel will place squiggly braces { } around the formula:
{=AVERAGE(IF(A1:A4="X",B1:B4))}
You cannot just type the braces in, you MUST use the key combo.
Biff
"J" wrote in message
...
i have two columns and want to search through a column for X and take the
average of all the cells that are next to X. for example:
W .2
X .4
X .3
T .9
the desired result is that the cell will have the value of the average of
cells next to X: (.4+.3)/2 = .35
when i type in AVERAGE(IF(col1="X",col2)) i end up with an average of all
values in col2 which is not what i want. any ideas? thanks in advance
|