ExcelBanter - View Single Post - Is it possible to use a cell reference to define the database?

Don Guillett

glad to help

--
Don Guillett
SalesAid Software

"PerplexedinKY" wrote in message
...
Worked like a charm, thanks.

"Don Guillett" wrote:

Have a look in the help index for INDIRECT

--
Don Guillett
SalesAid Software

"PerplexedinKY" wrote in
message
...
Hello,

I am using the dsum function in a worksheet. I need to know if it
would
be
possible to use a cell reference to define the database range. For
example
my formula now is =dsum(Market, "Count", Branch Name). What I need to
be
able to do is have it =dsum(c3, "Count", Branch Name). Where cell c3
contains the text Market. Is what I am trying to do possible? Thanks
in
advance for your help.