SUMIFS With Wildcard | Excel Sum based on Partial Text Match
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- Remember when we do not have any condition or criteria Sum is sufficient,When we have either one or more criteria Sumif and Sumifs function is there.
Now learn how to SUM values in Excel based on a partial text match or we can say fuzzy match.
For these cases you can use SUMIF or SUMIFS function together with wildcards. Examples of wildcards are the asterisk "*" sign or the Question mark "?".
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#sumiffunction #wildcard #Innozant #Sumifswithwildcard #exceltips #ExcelTutorial
वाकई में गुरुओं की श्रेणी में सर्वोच्च गुरु का स्थान है आपका, बहुत ही अच्छा बताते है आप। बहुत बहुत शुक्रिया आपका sir
Thanks Sushil Ji..God bless you dear..Mujhse sabse jyada khushi tab hogi jab aap job like dikhaoge mis profile me
Also this video will realy help you -- th-cam.com/video/c5aM8g7gQtY/w-d-xo.html
Sir , I have seen hundreds of Excel video but when I see your videos , I always learn something new . Thanks for informative video. Your are the best online tutor I seen.
Thanks Shirakawa,Really means a lot to me dear...God bless you. tc
Also this video will realy help you -- th-cam.com/video/c5aM8g7gQtY/w-d-xo.html
Like tho Innozant ka birth right hai Sir ji .. thank you..
Thanks dear
सर आपने बिल्कुल सही बात कही जब खूद करने बैठते है तो आपका विडिओ तीन तीन बार देखना पड़ता है , पर आखिर में सफलता जरूर मिलती है ।
👍
Sir ,You are the best teacher i have ever come across for excel training.. God Bless you.
Thanks Dear
Sir ji mai guarantee ke saath kaheta hu ki aapse acchaa MS office ka teacher TH-cam par nahi hoga aap bahut accha padate ho aap mere favourite teacher ho sir ji..
Thanks and Love you dear...For your love and support
ye concept to kabhi dekha nhi tha office use me, aaj pahli bar dekha , bahut badhya hai
👍❤️
Thank you so much Sir. You are a great teacher........!!
aap har 1 topic ko achhese explain karte ho, jisase har 1 concept achhese clear ho raha hai.
Thanks Satish Ji .aapke itne pyare comment ke liye.Happy Learning dear.
You are my favorite TH-cam teacher dear sir
You are giving good knowledge..so Grateful to you...🎉🙏 God bless you...
Thanks dear
Sir, you explain so well that problems are solved quickly
Thanks dear
দারুন , এর আগে অনেক ভিডিও দেখেছি , এত সুন্দর নয়।
Genius always Genius
Dear Sir, really i learn a lot from your video, thanks is a very small word to express my gratitude to you,i just want to ask a stupid question ---- Sir what key board short cut you use to freeze the column & row
Thq so much sir
Thank you so much Sir, these videos helps me a lot to understand that topics I cover in classes.
Thanks Suraj ji🙏❤️
❤great teacher ❤
Good morning guruji 🙏
You are the best sir
Thanks Krishna
SIr can U please send us Shortcut tricks to Freeze Row & Column and please share datasheet also for practicing.
Also this video will realy help you -- th-cam.com/video/c5aM8g7gQtY/w-d-xo.html
Please explain with example - =SUMIF(NDT!$B:$B,Summary!$A11,NDT!H:H)
Very healthful formula sir I have ever been used
Thanks dear
Thanks you for giving such kind of assignment.
Thanks Manjeet Ji
Thanks sir 😊
every video is nice.
Thanks Monty, Watch Videos from playlist catagory wise step by step.
Thank u sir.....practice makes perfect ❤️
Thanks Sir
Tussi grate ho sir
Thank you 😊😊😊 sir, your contents really out of the box 👍👍👍
Thanks Jackir Sahab for such a valuable feedback dear..Love you all..❤️🙏
I really appreciate everything that you do.
Thanks Rohit Ji
great sir from pk.
Thanks dear❤️😊
Great sir 👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌
Very good Msg.
Love you Bro
Thanks Prakash
Right Sir Without practise k samajh nhi ayega.
Offcourse practice is must
wow sir jhaka naka
Dhanyawaad 🙏
Sir, I am 32 and have almost 7.5 years experience in different profiles (29 months experience of WIPRO BPO + 4 years experience as a DOCUMENT CONTROLLER in Saudi Arabia + 1 year experience as an ADMIN CLEARK also in Saudi Arabia).
Sir if I learn advance excel and SQL, can I get a job as a data analyst?
Am I too old to start my carrier as a data analyst?
Sir please do reply.
32 age is nothing dear..Yahan to log 40+ me switch kar jate hain..MIS data analytics is very good field you may opt for your career .Who knows that you are not working as Data analyst..??Only You..🙂Just try to gain skills and based on that go for interview .If you want further gudance or confused to start your career.You are free to whatsapp/call us.Thanks for showing your interest in mis and data analytics..Go ahead Sheikh sahab age is just a number.
@@Innozant Thank you so much sir for your full of inspiration reply....
I definitely gonna meet you once i come to Delhi
👍👍❤🙏
great
❤❤❤❤
tnx sir
🙏🙏
Nice Sir.. ❤️
Sir if I want to find the sum of the marks of the students who have more than 4 characters in their name, then how to do that?
Sir MIS ki job me typing speed ki training jaruri h?
Bilkul nahi dear..typing se reporter ka kya role
Sir plz uploading powerbi video sir plz we are needing power bi plz sir
But ? Mark number par work nahi hota
New for me sr great
Thnq sir
i love it
Great
👌👌👌👌👌👌👌
Sir Agar month ki salary banaate hai koi Half day liya kabhi nhi liya yese sab karte hai
Ab months main sabka sahi count kaise kare
Haan to koi to parameter set Karna Hoga na..us criteria ko base manke lagaiye formula
🙏
Waiting for the VBA part..
sure..after some time
wese mujai samaj nahi araha k ye jo 3 gentlemen hai. in logo nai iss video ko dislike q kiya hai?.. i mean amazing
Haha..bechare masala dekhne ke ummed me video on kiya hoga aur padhne ko mil gya.mau be thats why
Thq Zahoor for your valuable appreciation.
👌🏻💐
👌👌
Dear sir pls support to make my carrier with MIS job....pls give guidance... 🙏
Pehle apni skills badhaiye kisi ke support ki jarurat NH h aapko.. confident rhenge to interview crack bhi hoga
👌🏻👌🏻
sir ma aba ma apka liya kya bolu mara pass koi words tak nhi h
kasha ma apka sath hota sir
liken marco Mis karna h liken thoda time bada karna h Mujha advance Excel or SQL mujha apki tara banna h bas
sir jhaka naka
Ye video jisne bhi sir sumif samajhke chhod diya, uska bada loss hua
Thanks Shrikant Ji .Very true👍❤️
Thanks sir
wow sir jhaka naka
❤️❤️❤️❤️❤️
wow sir jhaka naka
wow sir jhaka naka
wow sir jhaka naka
wow sir jhaka naka
wow sir jhaka naka
wow sir jhaka naka
wow sir jhaka naka
wow sir jhaka naka