incorrect result of nested functions

[Alfredo]

I am trying to use the functions below but I am having
problems. The result in the assistant of functions this
correct one, but the result in the cell after OK is of the
whole group, disrespecting the selection.
MÉDIA(SE(A1:A10=11;B1:B10))
A = 11, 11, 11, 12, 12, 12, 13, 13, 13, 13
B = 1, 2, 6, 11, 14, 15, 21, 23, 24, 30
Answer in the assistant = 3 (OK!)
Answer in the cell = 14,7
What am making wrong?
For the attention, in advance I thank.
Alfredo

 

[Ken Wright]

Did you array enter the formula using CTRL+SHIFT+ENTER??

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------



I am trying to use the functions below but I am having
problems. The result in the assistant of functions this
correct one, but the result in the cell after OK is of the
whole group, disrespecting the selection.
MÉDIA(SE(A1:A10=11;B1:B10))
A = 11, 11, 11, 12, 12, 12, 13, 13, 13, 13
B = 1, 2, 6, 11, 14, 15, 21, 23, 24, 30
Answer in the assistant = 3 (OK!)
Answer in the cell = 14,7
What am making wrong?
For the attention, in advance I thank.
Alfredo

 

[Frank Kabel]

Hi Alfredo
you have to enter this formula as array formula with CTRL+SHIFT+ENTER
(instead on only using ENTER).