"Bob Phillips" wrote...
SUMPRODUCT is case agnostic as well, but your formula is wrong.

This will work in Excel, but I can't guarantee StarOffice as I don't have
it

=SUMPRODUCT(--(A31:A10000TODAY()-90),--(F31:F10000=D18),M31:M10000)

or

=SUMPRODUCT((A31:A10000TODAY()-90)*(F31:F10000=D18)*(M31:M10000))

I have SO/OOo, and this type of SUMPRODUCT formula won't work in SO/OOo
Calc. With 1, 2, 3, 4 in A1:A4, 1, 10, 100, 1000 in B1:B4, the formula

=SUMPRODUCT((A1:A42)*B1:B4)

returns #VALUE! in SO/OOo whether entered normally or as an array formula.
SO/OOo array capabilities are limited to ranges as operands and arguments to
MDETERM, MINVERSE, MMULT and TRANSPOSE only. There's no support for derived
array expressions.