G

#### Guest

but I couldn't find an answer to this specific question on previous posts.

I'm trying to use the DSUM function and copy the formula down a column of

all rows where my criteria data resides. The field names in row #1 and

records containing criteria starting at row #2. Is there any way that DSUM

can do this? The formula obviously works for my first data record (row 2)

that contains criteria where the criteria argument would be for example

D1:E2. But when I want to evaluate the criteria on the second data record I

haven't figured out how to both reference the field names (D$1:E$1) and the

criteria set for this specific row (D3:E3).

....and then the next record referencing the field names (D$1:E$1) and the

criteria (D4:E4) and so on.

I think it would be great to really leverage the functionality of a

spreadsheet with a basic multiple criteria join instead of having to use

Access to make this type of join.

Thanks in advance for your suggestions.