[libreoffice-users] Re: averaging with missing values

On 2/15/2014 11:49 AM, Regina Henschel wrote:
> Hi William,
>
> william drescher schrieb:
> > I have a table of systolic bloop pressures: 4 rows (weeks) x 21
> > cols
> > (days) eg:
> >
> > week 1 130 133 140 ... (representing morning, noon, night of
> > day 1 -
> > followed by morning, noon and night of day 2..7)
> >
> > I want to compute the average pressure for the week.  In a
> > perfect world
> > I would just use the average function.
> > However, in this world I find that each row has between 3 and
> > 10 missing
> > values.  To get the average now I sum the row's values and then
> > divide
> > by the number of values in the row.
> >
> > Can anyone suggest a way of getting the average without needing to
> > manually count the values ?
>
> If the cells are really empty or have a function call that
> results in a text, then such cells will not be counted by the
> AVERAGE function. If the cells contain a formula, which results
> in 0, then you can use AVERAGEIF(range;"<>0").
>
> Kind regards
> Regina

Thank you for the information - couldn't be easier
--bill


--
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