How to convert whole array to upper

P

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compacting UPPER/LOWER & column reference 1
Workaround for LOWER(A1:A100) 4
Workaround for UPPER(F31:F10000) 1
SUMIF for variable cell range 1
Convert list to UPPER, lower & Proper cases. 21
how to make whole work sheet in to upper case 4
How do I convert from UPPER to lower case? 4
how to convert int32 to byte array 9

Top