#value! on spreadsheet when formula palette gets correct result

[wingham]

=AVERAGE(IF(C5:C14="Europe",D514)), an example in the help, gives correct
result within the palette formula editor, but the #value! is all that shows
up in the spreadsheet.

 

[duane]

do you enter as an array (control + shift + enter)?

 

[wingham]

Thanks - it works now like it is supposed to! Thanks again