How do i make this formula not case sensitive?

Originally Posted by abousetta

Hi Ron,

I tend to stay away from it anyways....

WHY??? In my Excel classes I spend 30 minutes covering "SUMPRODUCT, Excel's most versatile function"!