root mean square

[nmn]

I want to find the rms value of a series of numbers, say A1:A10. I can do this by using sqrt(average(B1:B10)), where the B column contains the squares of the values in the A column. What would really help me though, is if there was a way to do this without using a second column. Is this possible in excel 2000?

 

[Al Chara]

Have you taken a look at SUMSQ, I think it is in the analysis toolpak.

 

[nmn]

Figured it out:
SQRT(SUMSQ(A1:A10)/COUNTA(A1:A10))
Thanks Al!