View Single Post
  #1   Report Post  
Patty R.
 
Posts: n/a
Default #DIV/0 ERROR in AVERAGING

I am creating a worksheet for 2005 calendar year that shows averages.

AVERAGE(C6:AG6)

However, when I the cells are empty the #div/0! displays. I have been
trying to do the IF Function to display a 0 if there is nothing to Average.

Any help is greatly appreciated.

Thanks,
Patty R.