Dsum "#value!"

I was able to leave DynaCrit as a dynamic address inside the INDIRECT function. My problem was with the use of the cell address to return the field header (part number.) When I simply substituted COLUMN() with the header cell enclosed, everything worked.

So, if I insert

=DSUM(Data,COLUMN(),INDIRECT(DynaCrit))

into the same column as the part number code the DSUM works.

Now I just need to make the Dates dynamic. I can use

=">="&A14
="<="&A30

to select a date in the table to set the upper and lower date limits and the DSUM still works, so now all I need to do is set this up in the real workbook and give the user a couple of cells to use for the date ranges to query.

Thank you for turning me in the right direction. You guys are terrific!