Criteria field in dsum formula

J

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?
 
B

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)
 
S

ShaneDevenshire

Hi Jed,

1. The criteria argument should read something like D25:D26, 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top