DGET with a hardcoded array for "criteria"

I want to use the DGET function to populate a results table in an excel spreadsheet. Two of the "criteria" I'm using for the DGET function will be stored in the first row and first column of the output table. Unfortunately, it looks like DGET requires a contiguous array to be used as the "criteria" input. I have tried using an array constant (i.e. a hardcoded array using curly braces {}), but am getting errors. There seem to be two separate problems occurring:
1. The DGET function returns an error when I try to use an array constant
2. I don't think array constants can contain cell references; they literally have to be constants.

Any input will be greatly appreciated. I've attached a spreadsheet showing an example of the problem.

Thanks!

Hello
Personally I don't think the DGET function is suitable for hard coding variables as you're trying to do. Why not use Sumifs to achieve your results in the Goal table. See attachment.

Hope this helps.

Hi DBY,
Thanks for the response! I think you're right, sumifs is probably a much better way to go. I was attracted to the fact that dget automatically checks to make sure there is only a single entry that matches the criteria, which is good for error checking given that I will be working with many database tables. I guess I can always use a "countifs" as my error-checker to make sure there is only a single entry.

I'd still be interested to know if anyone can get the database functions to work with a non-contiguous array, as I might like to use some of the other database functions (e.g. dproduct) in a similar way.

Thank you Haseeb!

Thank you , I didn t know about sumifs