Dsum "#value!"

I have been trying to follow along with Chip Pearson's DSUM Tutorial and apply it to an application here at work.

It is located at http://www.cpearson.com/Newsletter/C...2007_10_08.htm

I am trying to sum the production totals for item codes between two dates. I eventually want the dates to be dynamicly set by a user input, but I cannot even get the DSUM to work using hard entered values. I have tried entering actual dates, the serial numbers for the dates and everything else I can think of.

I am enclosing a zip of a small sample of the worksheet, I have even used the same names Chip Pearson uses in his tutorial, just applying them to the ranges in this sample.

If anyone can tell me where I am going wrong, I would be most appreciative.