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.