Workaround for UPPER(F31:F10000)
 

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

It's best if you remain in the same thread.
It keeps things coherent since the posts are *not usually* this close
together, this being a slow weekend.

I can't speak for SO, but I've *never* experienced *any* case sensitivity
when it comes to SumProduct in XL.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pantryman" wrote in message
...

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