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
Watch video SUM Cells Based on Partial Text Match (Easy Formulas) online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 07 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,831 once and liked it 259 people.