Please clarify the meaning of "It didn't work". If array entered, the
formula will produce the standard deviation of the values in column F divided
by 1000000 that correspond to values in column E which equal K17. Was the
formula not array entered, or was that standard deviation not what you
wanted?

Another possibility is that there may be issues with the matching to K17.
IF K17 appears to be a number, either it or some of the "matching values" may
be a string instead of a number, an therefore not a match. If K17 is
supposed to be a string, there may be differences in trailing spaces that
prevent a match.

Jerry

"Harimau" wrote:

It didn't work, unfortunately. :(

"T. Valko" wrote:

Try it like this: (array entered)

=STDEV(IF($E$2:$E$296=K17,$F$2:$F$296/1000000))

Biff