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!
-Ryan
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, ...
Keep watching.
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:
=SUM(January.H35:December.H35)/(COUNT(January.H35:December.H35)-FREQUENCY(January.H35:December.H35;0))
[...] 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?!
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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/
All messages sent to this list will be publicly archived and cannot be deleted
