averaging with missing values

users
#1

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

#2

Hi Regina,

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").

Thanks for the pointer, but... well, I didn't find any MOYENNE.SI() (or
equivalent) in my FR version 4.1.4.2 Statistics functions. Thus my
suggestion to simulate one :,(

Hu? Yes, there is, but classified in the Math functions, while AVERAGE()
[MOYENNE() in FR] is classified in Statistics :,(

Thanks for the heads up.

#3

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