2

I would like to calculate the standard deviation of a population of many values, while the last value changes daily. Therefore, I would like to specify the range for the calculation from field G21 to whatever the last value in column G is.

I have been trying the formula for the lastest value, and this returns an error. The formula I am trying to use is:

=STDEVP($G$21:(LOOKUP(9.99E+307,$G$22:$G1000)))

How could I do this?

Thanks for any inputs.

codemania
  • 1,098
  • 1
  • 9
  • 26
user3333198
  • 105
  • 1
  • 4
  • 15

1 Answers1

0

Try this one:

=STDEVP($G$21:INDEX($G$22:$G1000,MATCH(9.99E+307,$G$22:$G1000)))
Dmitry Pavliv
  • 35,333
  • 13
  • 79
  • 80