Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AVERAGE(IF()) problem
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
AVERAGEIF problem | Excel Worksheet Functions |