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
nice tutorial. i have one query . how can you sum if a column contains US or canada both. right now in the video you have shown only with word US. what if i want total sales of US and CANADA.
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🙏
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 ?
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.
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
nice tutorial. i have one query . how can you sum if a column contains US or canada both. right now in the video you have shown only with word US. what if i want total sales of US and CANADA.
This is literally the best channel to learn any excel stuff! Thank you so much Sumit sir for such videos! :)
Yayy.. thank you for the kind words. Makes me happy to see that the videos are helpful 🙂
Thank you Sumit!!
This is brilliant 👏👏👏
Superb
👍 useful to know wildcard functionality
Glad you found the video helpful 🙂
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🙏
Thank you so much for the kind words 🙂 More power to you!
@@trumpexcel Than you sir for replying on my comment. You made my day❤️
Very important to manage wildcards.
Thanks for the video, Sumit.
this is a god gift channel to me Thank you for making video and teaching us 😍
Thank you so much for the kind words.. I am happy to know that the videos are helpful ☺️
Great, awesome. Really helpful in day to day work.
Thanks Rajeev... Glad you found it helpful 🙂
Great technique! Thank you.
Glad it was helpful!
Great solution- thank you! Is there a way to make the criteria case insensitive?
Thanks :)
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?
Yes, that would work when the asterisk in the beginning
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 ?
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.
Request you to attached Excel file for practising .🙏
👍❤
What if the asterisk is at the beginning?
You can use ~** in that case
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