Hi,

What help means is that you can only pass 30 arguments to stdev for example:-

=stdev(a1,a2,a3-------A30) is OK
=stdev(a1,a2,a3-------A50) isn't OK
but this

=STDEV(A1:A100)

calculates the standard deviation for 100 cells and only counts as a single
argument.


Mike

"Svi" wrote:

I have a datasheet with data of more than 30 people. I want to calculate the
standard deviation, but the Help function of Excel tells me that Stdev is
used for a group of max 30 persons. What function should I use to calculate
the standard deviation for a group of more than 30 people?

J.A. van Iwaarden