welcome, and thanks for the explanation, John.
glad to hear you found what you were after.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"johndonnelly" wrote in message
...
Hi Max,

Thanks. That formula works. In case you want to know I found another post
that answers it.

I like to use criteria ranges because when one of the accountants adds an
account I just add to the list. Anyway if in the criteria range you just
put
a string the DSUM formula looks for the presence of that string in all
cells
whether or not the cell contents includes other characters. To make the
selection specific the criteria must be preceded by an equal sign in the
cell
such as =446B not just 446B. This way it will not select cells containing
characters other than the criteria such as 446BA.

Anyway thanks for your help Max, I appreciate it.
--
John Donnelly