I read your solution, but do not want to alter any cells or add new ones
as the spreadsheets are formatted to fit onto a single sheet of paper. I
am going to test the solution using frequency right now. It looks
perfect to me, but I won't know until I put some data into the sheets
and see what happens. I will report back soon. Thank you all for your
suggestions and feedback!
On 1/5/2014 2:41 PM, Brian Barker wrote:
At 11:35 05/01/2014 -0500, Ryan Ashley wrote:
On 01/04/2014 08:12 PM, Brian Barker wrote:
At 19:10 04/01/2014 -0500, Ryan Ashley wrote:
Maybe someone else knows a way to do it using existing functions, ...
At 21:38 04/01/2014 -0500, Ryan Ashley wrote:
... is there any possible way to do this in LO?
This is a messy workaround, but it appears to work:
[...] For now, is there any way to get the average of cell H35 across
all of my sheets without adding other sheets or modifying my layout?
Yes. Did you not read my solution - that you quoted in your message?!
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF... · Hylton Conacher (ZR1HPC)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy