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