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