DSUM using critera in non-consecutive cells

[alberto]

Hi,

When using DSUM, I would need to have the labels for the criteria and the criteria themselves in non-consecutive rows (e.g. the label would be in A1, there would be a criteria in A2 which I do not want to consider, and the critera I would like to use for the sum is in A3).

Any advice?

Thanks in advance,
Alberto

[Lotus123]

I don't believe we have enough info to answer this question (which is probably why it has gone a few days without an answer):

Presuming original data:
Color Rank Value
Red 5 1
Orange 6 2
Green 7 3

This formula returns "6" as the total of the third column:
=DSUM(A1:C4,"Value",A1:C4)

If you wanted the total of Rank, you would use this function:
=DSUM(A1:C4,"Rank",A1:C4)

You might take a look at SUMPRODUCT....in my opinion it is much more powerful than DSUM.