Hi Regina,
> But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)} for example.
Besides the typo, for that to work it would need to be all in the same
worksheet, which is contrary to the initial setup.
ISTM that using SUM() and COUNT() would be simpler, if the data is
already with the layout as described, in multiple sheets.
Regards,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
