How to SUM by matching partial text in Excel In this tutorial, I'm going to share another tips on how to sum by matching partial text in Excel . First of all, Microsoft Excel has a function called, "SUMIFS". Also has SUMIF. But I'll work here with "SUMIFS". This function allows us to sum a specific range. Based on some specific conditions. The situation of your condition is different in real life. As a result, I'm writing how to sum by matching partial text in excel tutorial. How to sum by matching partial text example: if you want to SUM only the BD based name shown in the list below, what will you do? Image 1: How to SUM by matching partial text in Excel Well, in this case You can do by following below steps: So, as you can see, I have to check all cells and find if the string “BD” appears in the cell or not, and if it does, I need to include the value in the adjacent cell in column B while doing the sum. The
Learn Microsoft Excel with step by step tutorials including charts, formulas, functions, Power BI, Excel VBA for beginners.