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

woops, that sent before I had a chance to finish....

So, I've tried =STDEV(CO12:INDEX(CO:CO,ROW()-1)) but that will want to
calculate the whole column. I need it to be from CO12:"infinity"

also, because of how the worksheet is built, I can't easily move this
formula out of the CO column.

Thanks!

"John" wrote:

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

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

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

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

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