I need some help from you guys i am currently using this formula to refrence a efficiancy rating on a production line in my plant =J6/L6 and when i do not have nay data entered of course i get the DIV/0 error... I am graphing the resulting data on a seprate page in the workbook and am refrenceing the following cell on the other sheet ='4'!$K7 i of course get the DIV/0 error. I need to sum up all of the days in the month with a rolling average and i cannot get the info to dispaly without the error...
I would appreciate some ideas and if anyone can solve this MOST LIKELY easy issue for me i would appreciate it
thanks allot
Bookmarks