Using a formula on anumber of cells in a column that the user inpu

C

Charissa

Hi,
I would like to be able to calculate the standard deviation of the first 'n'
cells in a column, where 'n' is a value entered into a cell by the user. Is
this possible to do without a macro?
Thank you,
~Charissa
 
T

Toppers

try:

=STDEV(INDIRECT("B1:B"& C1))

Where column B contains the data and C1 contains n

HTH
 
Top