How do i make this formula not case sensitive?

I guess I never got the hang of it, but also because of suggestions like this from MSDN (http://msdn.microsoft.com/en-us/library/ff726673.aspx):

"Starting in Excel 2007, you should always use the SUMIFS, COUNTIFS, and AVERAGEIFS functions instead of SUMPRODUCT formulas where possible."