I thought I was done but some other problem came up. What I'm doing is
adding up cells to get a value x then adding another set of cells to
get value y. I want to do this calculation x/y but getting the error
because x is zero therefore won't compute.

=(January!F47+February!F47+March!F47+April!F47+May !F82+June!F102+July!F67+August!F72+September!F62+O ctober!F47+November!F42+December!F42)/(January!G47+February!G47+March!G47+April!G47+May! G82+June!G102+July!G67+August!G72+September!G62+Oc tober!G47+November!G42+December!G42)

This is what I have. I'm trying to figure out what I need to add to
this equation to make that happen. I think I need do an IF statement
stating if the value is 0 then calculate, if it doesn't then put a
blank. This is important because lets say JanF47 is 1 but FebF47 is 0,
the computation is not allowed. Also, on the bottom side of the
division...if JanG47 is 1 but FebG47 is zero...doesn't like the
calculation. I want the calculation to ignore the zeros.

Hope you understand what I'm asking. I'm going to try several things
to see if it will work. Thanks again for your help.

Jason


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=491066