View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shail shail is offline
external usenet poster
 
Posts: 195
Default why can't I average 36 values?

hi Dave,

You should answer back in the Questioner's forum. Your answers are
always good, but I need the questions too.

Hope you will help me too to understand your posts.


Thanks,

Shail


Dave F wrote:
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?