Criteria field in dsum formula

[Jed]

I want to import the text from a cell into the criteria portion of a DSUM
formula (=DSUM(database,"field",criteria)

I am trying to do: =DSUM(DATABASE, "FIELD",=H25)

Cell H25 contains text from a result of a VLOOKUP.

The problem is that the text is not inserted...the cell numer H25 is.
The formula then treats H25 as the critera range and thus does not work.
Is there a way to import the text rather than he cell number?

 

[Bob Phillips]

The criteria has to be (at least) two cells, one for the field name, the
other for the value. Just add the VLOOKUP to the value cell and it should
work.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ShaneDevenshire]

Hi Jed,

1. The criteria argument should read something like D2526, there should
be no "=" sign in this part of the formula.
2. The DFunctions require two or more rows for the criteria area - the
first row is a title matching a title in your database area, the second row
is the criteria. Without this Excel doesn't know which field of the database
area you want to test the criteria against.