Hi RP,

SO doens't recognize -- and

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

still remains case sensitive and gives the same results.

Some posters here said SUMPRODUCT entered with CTRL SHIFT ENTER is
case-sensitive in Excel and it's always case sensitive in SO.
I can't crosscheck that since I don't have Excel.

Thanks for your suggestion though.

M.


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