Two separate issues. A_ The curly brackets are not to be introduced manually. They are only a sign that the formula is not "normal" (as introduced by pressing [ENTER]) but instead is an array formula, introduced by simultaneously pressing [CTRL]+[SHIFT]+[ENTER] (CSE). Search the wiki or the web for info.
B_ Not every function will accept 3D arguments (i.e. ranges from different worksheets), even when using array formulas. You can use ABS() as an array formula, but within the same worksheet. Currently, ABS() does not accept 3D arguments, IIUC. I could be wrong. So, you would have to use ABS() in each sheet (as normal or as CSE), and then you can use AVERAGE() as a 3D formula, whether with [ENTER] alone or with CSE, depending on the specific case. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
