Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

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: users+unsubscribe@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/
All messages sent to this list will be publicly archived and cannot be deleted