Is it possible to use a cell reference to define the database?
 

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.

Is it possible to use a cell reference to define the database?
 

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.

Is it possible to use a cell reference to define the database?
 

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.

Is it possible to use a cell reference to define the database?
 

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.