Just to confirm Ron's reply:
AVERAGE(A:A) and AVERAGE(A1:A1000) work
The problem lies elsewhere.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brian Mc in StL" <Brian Mc in wrote in
message ...
I need to determine mean, median, mode, min, max and rank for a set of data
that exceeds a count of 255. Excel keeps locking up on me I think because
these functions are limited to arrays of 255 numbers or less.

Is there a way I can calculate these statistics on sets of data numbering
in
the thousands?