I am not very savy with Excel and when I searched for answers I couldn't understand what they were saying so I am starting my own thread. I have a sheet in excel that has 4 columns in it (one column for each of our locations). I have 52 horizontal rows representing each week of the year. Each cell has a formula in it to pull the value from other sheets within the workbook. Those values then get plotted on my graph for each week. I am in week 45 which is plotted correctly, but all weeks after bring my line down to "0" because the formula is in the cell but I have not calculated the values yet. My formula for one of the cells look like this: =SUM('Southbury 4-2013'!L11). So basically, for our Southbury location, it is plotting the L11 value from the sheet that is titled Southbury 4-2013. If I haven't filled out Southbury 4-2013 sheet yet then it is plotting the number at 0 instead of just not plotting it at all (which is what I want). How can I fix this, if I can fix it at all? Thank you!
Bookmarks