I think I figured it out...:
=STDEV(INDIRECT("$CO$12"):$CO$92)

And seeing your formula I think I figured out what you meant by dynamically
adding rows. You're inserting rows and you want the formula to always start
from CO12.

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
I think I figured it out...:
=STDEV(INDIRECT("$CO$12"):$CO$92)


"John" wrote:

Hi T, thanks. Is there any way to get around the "no empty cells in the
range" issue?

Also, isn't your formula limited to 65,536 rows??


"T. Valko" wrote:

Not sure what you're looking for but why not just do this:

=STDEV(CO12:CO65536)

Empty cells are ignored but you need at least 2 numbers in the range to
calculate otherwise you get an error.

Or, if you really do want a dynamic range assuming there will be no
empty
cells *within* the range and the range contains only numbers:

=STDEV(CO12:INDEX(CO12:CO65536,COUNT(CO12:CO65536) ))


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Hi everyone, I hope some can help me with this:

I need to run a standard deviation on a range within a column that
start
at
CO12 and goes on to dynamically added rows

So far I've tried:

=STDEV(CO12:INDEX(CO:CO,ROW()-1))