How to calculate the SD of multiple cells not in a row

[Markus123]

Hello guys, it's 4am where i am and i have been working on this project for 8 hours. I cannot find the simple solution on google.

I basically have an array of cells that are not in a column or row (cannot organize them either as the file is quite large) that contain numbers and i need to know the SD of all the cells.

I've tried =STDEV(cell+cell+cell+infinity) this is for over 90 cells, and it does not give me the answer i need.

please help. If i'm not making much sense i apologize i am very sleep deprived.

 

[Aladin Akyurek]

Do you mean you have numbers in a set of non-contigious cells like A2, F4, J2, N8, N20, etc?

 

[Markus123]

Yes, precisely. Do you have a solution Aladin? i would be most grateful.

 

[Aladin Akyurek]

Yes, precisely. Do you have a solution Aladin? i would be most grateful.

Put the relevant cells in-between of a pair of parens and feed that to STDEV...

=STDEV((A2, F4, J2, N8, N20))

 

[joeu2004]

I've tried =STDEV(cell+cell+cell+infinity) this is for over 90 cells, and it does not give me the answer i need.

The correct syntax is: STDEV(ref1, ref2, ..., ref254), where "refN" can be a range or a single cell reference. The use of comma or semicolon separators depends on your region.

Nevertheless, that is tedious for 90+ references. And you might encounter the limit on formula length.

 

[Markus123]

ah my god so silly!, i can't believe i was putting pluses instead of commas, Thank you Aladin & Joe.