How to convert whole array to upper

[Pantryman]

Hi,

I just finished my logbook, but one problem remains.

Is it possible to consider a whole array as upper?

The formula is:

=SUMPRODUCT(--(A31:A10000>TODAY()-90),--(F31:F10000=D20),M31:M10000)

But I cannot find a way to have contents of F counted regardless o
case of D20.

My thought was to use UPPER(F31:F10000)=UPPER(D20) but that doens'
work.

Thanks for any help

 

[Jason Morin]

You shouldn't have to convert your range in F col. or
D20. A direct comparison using "=" is not case-sensitive.
For example:

My Name = MY NAME ---> TRUE
my name = MY NAME ---> TRUE
My Name = my name ---> TRUE

HTH
Jason
Atlanta, GA