Currently have the formula =COUNTIFS(Data!$C:$C,E8,Data!G:G,"<0") to return the # of items less than 0. Cell E8 is now a problem because I have an "s" and a "S" to match. How would I update formula to get the exact match? having the same issue with =SUMIFS(Data!$J:$J,Data!$C:$C,E8,Data!G:G,"<0")




Thank you,