Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workaround for LOWER(A1:A100) | Excel Worksheet Functions |