Dget problem. More than one row

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 add
more rows to the Dget (Dhämta in swedish) function things starts to get
interesting as you can see in the picture (exempel 2).
In this case I would like The function in G13 show the result 30, G14
to show 20 and G15 to show 25.

Can this be done or should I use adifferent function?


---
Message posted from http://www.ExcelForum.com/

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)

Loranga wrote:
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 add
more rows to the Dget (Dhämta in swedish) function things starts to get
interesting as you can see in the picture (exempel 2).
In this case I would like The function in G13 show the result 30, G14
to show 20 and G15 to show 25.

Can this be done or should I use adifferent function?


---
Message posted from http://www.ExcelForum.com/



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html