Last year we talked about the importance of not ignoring missing data. This means we have to be careful how we record data so that we know when data is really missing and can distinguish that from a result of zero. Jonathan Callahan gives some good examples of the difference in this post and shows you how you should handle each in Excel.
Zero vs. Missing. http://mazamascience.com/WorkingWithData/?p=343