View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default why can't I average 36 values?

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?