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

G

Guest

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
 
G

Guest

try:

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

Where column B contains the data and C1 contains n

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to return a formula 1
Ignoring Cells Returning #N/A 4
Please help on formula that will not work (If-And formula) 3
Sum column of cells that already contain a formula 2
Standard Deviation w/ multiple criteria... 1
Need help with a formula, please!!! 2
Finding Last value in a column 2
How to do calculations with Null in the column? 4

Top