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))

--

HTH

RP

"Pantryman" wrote in message
...

Hi,

I'm using StarOffice Calc which does not recognize a case ident for a
cell range, i.e. UPPER(F31:F10000)

The problem is that I'm using SUMPRODUCT (case sensitive, also in
Excel) and need to get a count for any hit on D18 (for example AAA) in
F31:F10000 which may contain any combination of AAA, AaA, aaA
..........

SUMIF would work since it's not case sensitive but I'm using more than
one criteria.

The comparable Excel formula is

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

I also can't use --

Any ideas?

Thanks!


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