limits for DSUM( ) ?

[Nancy]

Does anyone know of limits in using DSUM()? I could need
approx. 400 separate DSUM statements in a single
spreadsheet. The results of DSUM statements could be
embedded in formulas nested several layers deep.

Also would like to hear of any known pitfalls using DSUM.

thanks!

 

[Peo Sjoblom]

I hardly ever use it.. One pitfall that I know of is that it
won't work on closed workbooks. The only bonus I know it that is faster
than sumproduct..

 

[Harlan Grove]

I hardly ever use it.. One pitfall that I know of is that it
won't work on closed workbooks. The only bonus I know it that is faster
than sumproduct..

...

Possibly slower than SUMPRODUCT is SQL.REQUEST, but it'll work against closed
files, and it's a heck of a lot more flexible than DSUM. See Andy Wiggins's site
for details.

http://www.BygSoftware.com

What, precisely, are you trying to do? It's possible that a combination of one
DSUM formula used in conjunction with a data table may be sufficient to meet
your needs, but without details it's impossible to be certain.