LinkedIn Facebook Twitter Gmail By default, the SUMIFS function is not case-sensitive. To make it case-sensitive and do an exact match, follow the below steps: SUMIFS COMPLETE EXACT MATCH Alternative 1: Using a combination of SUM, IF & EXACT We shall start by doing a complete exact match then a partial exact match How do … Continue reading HOW TO SUMIFS EXACT MATCH IN EXCEL