Note that the average of the averages of unequal ranges may not be the same
as the average of the whole range.
e.g avgerage of 100 = 100, average of 1,1,1 = 1
average of averages is about 50, average of the four values is about 25.


"Dave F" wrote in message
...
What formula are you using?

I'm not aware of such a limit, however, if there were such a limit, the
solution would be to split the range of cells to be averaged into to
ranges,
average each of those ranges, and then average the two averages.

Dave
--
Brevity is the soul of wit.


"pingwin77" wrote:

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?