Easy Excel question

[BobTheSlob]

I have this line

=STDEV(E21:E40 ?? E80:E101)

I need to get the standard deviation of only E21:E40 and E80:E101. How do I combine those 2 ranges? I can't just sum them or else I'll screw up my standard deviation. What's the operator to link a range together?

 

[cuemasterfl]

Try this:

=STDEV(E21:E40,E80:E101)

 

[BobTheSlob]

Hahaha, thanks. That did the trick nicely.

 

[cuemasterfl]

You're welcome. The easiest way to do this is:

1) Type =STDEV(
2) Drag and select the first range with the mouse and let go
3) Hold down CTRL and drag/select the second range and let go
4) Press enter

The values and operator sign are filled in for you.