SUM Cells Based on Partial Text Match (Easy Formulas)

Подписаться 375 тыс.

Просмотров 4,4 тыс.

50% 1

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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 29

@trumpexcel 5 месяцев назад

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

@AnonymousHehe7138 5 месяцев назад

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

@trumpexcel 5 месяцев назад

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

@playwithexcel7357 5 месяцев назад

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 5 месяцев назад

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

@playwithexcel7357 5 месяцев назад

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

@jhankhanajani9314 4 месяца назад

Thank you Sumit!!

@IvanCortinas_ES 5 месяцев назад

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

@canirmalchoudhary8173 4 месяца назад

👍 useful to know wildcard functionality

@trumpexcel 4 месяца назад

Glad you found the video helpful 🙂

@vikaasb2016 5 месяцев назад

This is brilliant 👏👏👏

@ashokkhegde 5 месяцев назад

Superb

@rajeevgosavi4514 5 месяцев назад

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

@trumpexcel 5 месяцев назад

Thanks Rajeev... Glad you found it helpful 🙂

@WrightViewLLC 5 месяцев назад

Great technique! Thank you.

@trumpexcel 5 месяцев назад

Glad it was helpful!

@Prajwalgk27 5 месяцев назад

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

@trumpexcel 5 месяцев назад

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

@user-dn5gd1rn9f 5 месяцев назад

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

@johnborg5419 5 месяцев назад

Thanks :)

@bentlauridsen8692 5 месяцев назад

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 5 месяцев назад

Yes, that would work when the asterisk in the beginning

@stlawrencechemical 5 месяцев назад

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 5 месяцев назад

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 .🙏

@kebincui 5 месяцев назад

👍❤

@user-cy2xq4ut1b 5 месяцев назад

What if the asterisk is at the beginning?

@trumpexcel 5 месяцев назад

You can use ~** in that case

@sujirpinna 5 месяцев назад

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