SUM IF Fuzzy Search

Google Sheets SUMIFS Wildcards: Sum Values by Text Inside a Cell (Fuzzy Match) This video shows how to sum sales totals in Google Sheets when the group label (like “- A” or “- B”) is embedded inside a text string, without first splitting the data into a separate group column. It demonstrates using SUMIFS with a wildcard asterisk (*) inside the criteria (e.g., "*A") to match any text that ends with a specific letter, selecting the sales column as the sum range and the text column as the criteria range. It also shows copying the formula for other groups, verifying results by highlighting matches, and building the criteria dynamically by concatenating a fixed pattern (like "- ") with a cell value using an ampersand (&) so you don’t have to edit each formula. 00:00 Problem Setup 00:32 Why Use SUMIFS 00:50 Pick Ranges 01:12 Wildcard Criteria 01:44 Validate Results 02:12 Dynamic Criteria 03:03 Wrap Up and Subscribe