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?
|