Bob Phillips wrote...
Thanks for that update.

I assume that array SUM(IF ... works okay. Is that correct?
...

Why would you assume that? The result of such an inner IF expression
would be a derived array, and as such isn't supported by SO/OOo Calc.

When it comes to conditional summing, SO/OOo Calc is very primitive.
Only the 123R2-like DSUM and other list functions are useful for
multiple condition sums and other aggregation calculations.

AFAIK, only gnumeric provides array formula functionality similar to
Excel. Quattro Pro and Xess provide different array functionality (and
I'll take Xess's @CSUM over Excel's SUMPRODUCT any time/every time),
and 123 provides much, much better database functions.

As a spreadsheet, SO/OOo Calc functionality falls somewhere between
Excel and the spreadsheet in Works. Not ready for real business use.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=273993