: I think the problem is not that you do not have a range, but that
: DSUM only works on a list or database. That is "a list of related
: data in which rows of related information are records, and columns
: of data are fields. The first row of the list contains labels for
: each column."
:
: The only workaround I can think of would be to copy the data to a
: new sheet - making sure it met the criteria for a database, do the
: DSUM, and then hide, or delete the sheet.
:
: Or, possibly, do separate DSUMs on each of the parts of the list
: and add them together.

I thought about that, but I figured there might be a way to
hold the range  in memory  only and then feed that range to DSUM.
The OP only needs to create  the criteria on the fly, so we can't
do separate runs, but a temporary spreadsheet to hold the criteria
would work.

Does a more knowledgeable person know if it is possible to
create a range in a VBA variable that can be fed to a function
without first creating the range on a spreadsheet?