I am trying to do some basic calculations (mostly finding the median of a range of values) using gnumeric. Unfortunately, this is giving me a hard time. Consider the following data:
0.04 0.04 0 0 0.08
0.07 0.03 0 0.01 0.11
0.05 0.04 0 0 0.09
0.06 0.03 0 0.01 0.1
0.05 0.04 0 0 0.09
0.07 0.03 0 0.01 0.11
0.06 0.03 0 0 0.09
0.07 0.03 0 0.01 0.11
0.05 0.04 0 0 0.09
0.06 0.03 0 0 0.09
When I try to calculate the median using a range by issuing =median(A1:A10)
, gnumerics result is #NUMBER, which I don't understand. The result is the same when using the syntax =median(A1;A2;A3;..)
. If I try to compute the sum by using =sum(A1:A10)
, the result is 0. What am I doing wrong? Do I have to format the columns in a specific way to make this work?