CTRL+SHIFT+ENTER???

[Terry]

Can someone describe how and when one enters the following fomula,
taken from a Kelly posting to use as an example, by using CTRL+
SHIFT+ENTER?

=AVERAGE(IF(A11>0,A1:A1))

TIA

 

[Frank Kabel]

Hi
this formulas has to be entered with CTRL+SHIFT+ENTEr always
See: http://www.cpearson.com/excel/array.htm
for an explanantion of array formulas

 

[Terry]

Thanks for the info' link Frank.

Regards Terry

 

[Aladin Akyurek]

An IF-part with a multi-cell range in its condition is diagnostic for a
formula that requires confirming with control+shift+enter instead of with
usual enter.