Dget problem. More than one row

[Loranga]

Aloha,

Here is a screen of my problem:
http://hem.bredband.net/maromb/exempel.JPG

The first exampel (Exempel 1) is working great. But when I want to ad
more rows to the Dget (Dhämta in swedish) function things starts to ge
interesting as you can see in the picture (exempel 2).
In this case I would like The function in G13 show the result 30, G1
to show 20 and G15 to show 25.

Can this be done or should I use adifferent function

 

[Debra Dalgleish]

DGET will return a #NUM! error if more than one record meets the
criteria (your 4th example)
In the other examples, the noncontiguous criteria range is causing the
#VALUE! error.

You could use SUMPRODUCT instead, although it would total the results
for all rows that match the criteria. For example:

=SUMPRODUCT(($A$5:$A$10=E15)*($B$5:$B$10=F15)*$C$5:$C$10)