This would help me with a dget function, but I would guess it’s not possible. I will maybe make another question if the answer to this one is that it doesn’t work, but if it does that would be much easier.
Maybe adding a condition in the criteria avoiding such rows. You can edit your question and attach a sample file.
There is no range reference operator to exclude specific ranges.
The tilde ~ is a range concatenate operator which conceivably could be used as <range before> ~ <range after>, but I cannot make it work for DGET().
The usual workaround is to add a filter condition to exclude the offending row. You may need to add a column for the “exclusion tag”. That column may be hidden.