View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RADIANT JILL RADIANT JILL is offline
external usenet poster
 
Posts: 1
Default AVERAGE FORMULA PROBLEM

I'm using EXCEL office 2003. I'm trying to average from several cells (which
have linked information from other pages), some of the cells have 0 in them.
I've looked up all the ways to have 0 not be included, and it works on all
the averages except when I'm bringing information from other pages. Since
this is a calendar, many of the months have no value. I've tried average IF
formula, using conditioning and formating page so 0 don't show, but no
success. :( Any other thoughts?