Using DGET function to work on multiple cells...

How do I use DGET function to return the values from a list.
Suppose I have a table of data as below:
Untitled0.png

I want to find out the below in one go:
Untitled.png

How do I do that?
I've attached a sample file to work on.
Thanks in advance

Or you could use SUMIFS in F22:

=SUMIFS(INDEX($D$3:$H$18,0,MATCH(F$21,$D$2:$H$2,0)),$C$3:$C$18,$D22,$B$3:$B$18,$E22)

Copy across and down as required.

Hope this helps.

Pete

Thanks both Glenn & Pete for your alternative methods. I know there are different ways of getting my output.

But I was actually hoping to use the DGET function itself to do this kind of operations...is it impossible to do that?

Nothing like that..its just that DGET function is very simple and short for multi criteria lookups and I work with multi criteria lookups very often that's why I was hoping that there might be a way for my requirement and thats all, if there isn't any option in DGET then I'll have to go with other options and also I was just curious.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete