How do i make this formula not case sensitive?

Hi Ron,

Thanks for the confirmation. Half the posts I read that Sumproduct is volatile and the other half say its not. Sometimes I'm not sure who to believe. I tend to stay away from it anyways because I rarely work on Excel 03 or before so it's not a big issue for me, but I know this comes up alot when people don't have the newer versions of Office available to them.

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"!