SUM Cells Based on Partial Text Match (Easy Formulas)

Рет қаралды 4,325

Күн бұрын

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 - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Пікірлер: 29

@trumpexcel 4 ай бұрын

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@playwithexcel7357 4 ай бұрын

Wow, this is a really good trick. I am so thankful to you Sir. I have been following you for quite a long time and you have played a major player in making me a Corporate Trainer for Advanced Excel for the past 5 years. Thanks a ton🙏

@trumpexcel 4 ай бұрын

Thank you so much for the kind words 🙂 More power to you!

@playwithexcel7357 4 ай бұрын

@@trumpexcel Than you sir for replying on my comment. You made my day❤️

@AnonymousHehe7138 4 ай бұрын

This is literally the best channel to learn any excel stuff! Thank you so much Sumit sir for such videos! :)

@trumpexcel 4 ай бұрын

Yayy.. thank you for the kind words. Makes me happy to see that the videos are helpful 🙂

@jhankhanajani9314 3 ай бұрын

Thank you Sumit!!

@ashokkhegde 4 ай бұрын

Superb

@canirmalchoudhary8173 4 ай бұрын

👍 useful to know wildcard functionality

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@IvanCortinas_ES 4 ай бұрын

Very important to manage wildcards. Thanks for the video, Sumit.

@vikaasb2016 4 ай бұрын

This is brilliant 👏👏👏

@WrightViewLLC 4 ай бұрын

Great technique! Thank you.

@trumpexcel 4 ай бұрын

Glad it was helpful!

@rajeevgosavi4514 4 ай бұрын

Great, awesome. Really helpful in day to day work.

@trumpexcel 4 ай бұрын

Thanks Rajeev... Glad you found it helpful 🙂

@Prajwalgk27 4 ай бұрын

this is a god gift channel to me Thank you for making video and teaching us 😍

@trumpexcel 4 ай бұрын

Thank you so much for the kind words.. I am happy to know that the videos are helpful ☺️

@johnborg5419 4 ай бұрын

Thanks :)

@user-dn5gd1rn9f 4 ай бұрын

Great solution- thank you! Is there a way to make the criteria case insensitive?

@kebincui 4 ай бұрын

👍❤

@bentlauridsen8692 4 ай бұрын

could you have used =sumif(A2:A16,"~**",B2:B16) in case that the Asterix * is at the start of the text, or how should it be?

@trumpexcel 4 ай бұрын

Yes, that would work when the asterisk in the beginning

@stlawrencechemical 4 ай бұрын

In your example using *US* what happens if a name such as ie Claudius-Italy appears in your data ? Would Claudius number amount not appear in your US sum ?

@trumpexcel 4 ай бұрын

It won't be a problem in all cases except when the term US can be anywhere in the cell. In that case, something like this should work =SUM(ISNUMBER(FIND("US",A2:A16))*B2:B16). Since FIND is case sensitive, it would only consider when the tern US appears in upper case.

@MananKalantre 4 ай бұрын

Request you to attached Excel file for practising .🙏

@user-cy2xq4ut1b 4 ай бұрын

What if the asterisk is at the beginning?

@trumpexcel 4 ай бұрын

You can use ~** in that case

@sujirpinna 4 ай бұрын

Great Video Sumit , I need some advanced excel help and i have reached out to you for a Paid project via your email id . Pls do review and let me know