Function on dynamicly adding rows in column

  • Thread starter Thread starter John
  • Start date Start date
J

John

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!
 
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)))
 
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??
 
I think I figured it out...:
=STDEV(INDIRECT("$CO$12"):$CO$92)
Click to expand...

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.
 
Back
Top