Workaround for UPPER(F31:F10000)

[Pantryman]

Hi RP,

SO doens't recognize -- and

=SUMPRODUCT((A31:A10000>TODAY()-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 i
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

 

[Ragdyer]

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.