SUM Cells Based on Partial Text Match (Easy Formulas)
In this video, I will show you how to sum cells based on partial text match in Excel. This can easily be done using the SUMIF function along with a wild card character (*).
I cover various scenarios to show you what can be done with SUMIF/SUMIFS and wildcard characters.
00:00 Intro
00:12 Sum Cells with Partial Text at End
01:27 Sum Cells with Partial Text at Beginning
02:37 Sum Cells with Partial Text at Beginning and End
03:49 Sum Cells with Partial Text Match (Anywhere)
04:50 Sum Cells with Partial Text + Multiple Criteria
06:22 Sum Cells with Asterisk (Wildcard)
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
