Is there some kind of pattern, like every other cell? Every 5th cell?

You can always use multiple range references:

=AVERAGE((A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,
A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,
A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36))

There can be up to 30 arguments but using multiple range references the
above formula contains only 1 argument. Of course, you wouldn't need this
for the sample range used because it's a contiguous range. This is only an
example.

Biff

"pingwin77" wrote in message
...
I am trying to average 36 seperate values in 36 different cells but I keep
getting an error. Is there a limit on how many cells can be used in a
function? If not, what am I doing wrong? If there is a limit, how do I
get
around this issue?