I would have thought Excel's DSUM = Lotus' DSUM
Not quite. Lotus added refinements into later incarnations of DSUM
which were never duplicated into Excel. In Excel's version, for
example, you still need to use criteria blocks. That can be avoided in
later versions of Lotus, where @DSUM, @DCOUNT etc can be made to
perform more like Excel's SUMIF and COUNTIF functions. Generally
speaking, the more flexible syntaxes don't automatically translate
when you load a Lotus file into Excel.
To Darryl, I believe that unless your Lotus formulas use criteria
blocks (in which case they SHOULD still work, subject to a number of
factors including the phase of the moon and the alignment of the
planets) you'll need to manually convert them to Excel's SUMIF
formulas.
