Re: [libreoffice-users] averaging with missing values

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

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