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+unsubscr...@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