SURPRISING Sumifs Trick in Excel | SUMIFS Function Hindi 

Because of your tutorials, I quit the habit of helper columns and try to solve the problem in single formula. Thanks 🙏

Explanation is very clear sir, with your lecture not only learning the function, also learning how to think logically it is very clear thanks for your lecture.

Zabardast sir ji, you're one of the reason for my excel skills upgrade. Shaherana andaz mei sikhate ho love ur explanation

Your explanation easily understand, your teaching style is great.

Sir you are megical totur I have ever seen In my life how effortlessly you understand concept of complexity content of excel which is unbelievable 🙏

Wah sir amazing solution diya apny. You are genius sir g. Live long life sir

Ultimate explanation, very nice!! I don't have words to praise .AWESOME

Excel me mene aaj tak aisa koi nahi dekha ki jo aisa soch k (ek dum hatke) hame sikha raha ho.👏🙏😇

I AM SO HAPPY TO WATCH THIS VIDEO, THANKS A LOT WITH MY DEEP HEART.

Amazing tricks sir . 👏 . We enjoyed your video on you tube. Our knowledge is enhance day by day by following your channel . Stay healthy and stay blessed. 🙏

Wow...Great work...I am very happy to subscribe your channel and 100% satisfy with your teaching skill. Always I want to learn excel in depth and i have visited many you tube channels but never got satisfied. But now I got the right channel , finally....thanks and keep it up.

Namakar Sirjee, Bahot Badhiya aur Saral tarike se aapka explanation..... Dhanyawad.....

Your way of teaching is simply great.....

You are awesome👍 very useful . not only this but all videos are very knowledgeable. Thankuu sir

No comment, jis dedication & honesty ke sath app jo karte ho sir, wahi imandari agar har ek ka kaam main aa jaye toh yeh Desh sone ka ho jayega. Chahe politician, Doctor.... God Bless You.

SIRJI , REALLY YOUR TECHNIC STYLE AMAZING , I NEVER GO FOR ANY COMPUTER CLASS BUT BY YOU I LEARN TOO MUCH..THANK YOU👍👍👍

i am speechless sir...word nahi mil rahe hai kese tareef karu apki...You are best and top no 1.teacher in the world. of Excel

This video was professional level thankyou so much sir

So Nice Logic.. Thank you Sir...

GURU JI PRANAM .. tusi great ho sade india di hope ho

You are genius sir! Kya skill set hai aapke paas..you are my inspiration to grow 🤘🏼

Excellent 👌

Bahut shandaar Sir.

Amazing video sir 👍👍👍

Thank you sir very helpful video🥰

You are outstanding sir 👌👌🙏🙏

Behtareen...........🙏🙏🙏 Lots of respect

Amazing video sir

कया बात है साहेब प्रशंसनीय प्रस्तुति

Awesome trick sir.

Wonderful thanks Sir

Gajjjjjjjjjjjjab ka dimakh hai sir salute to level of thinking

Excellent sir

a true guru.

Excellent ❤❤❤

best channel

You're really doing great sir 👍👍👍👍

Thank you for uploading useful videos, regarding this particular tutorial, I stuck where the amount column imported as text instead of a number so applying the function not giving any output, so if you can suggest a way to fix the issue. Thank you again.

it is really good video and explain thing logicaly. You are really clever and sharp in excel.

You are just excellent

Great sir...👍

Very helpful 👍

your teaching is very nice.

Heartfelt Dua for you Brother ❤ from Bangladesh 🇧🇩

just looking like a wow

Great!

Thanks🌹❤🙏 bhaya

very useful sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

Very nice logic sir

absolutely fantastic

very very well tricks very nice

Thanks Sir

Super 👍

Bhot bdia

Maza aa gya video dekhke

Thnq sir so much

Just super

Great sir

Thnx u too much 😊

Sir I am from Pakistan, great works. Ab mujhe kisi institute ja k Excel seakhne ki zarorat nahi... Aap ne hamari mushkil hal kardi.

Osum 👍

Superb sir...👍

most super sir🙏

I have 5 years of exp in SAP and I hardly use Excel while working ...Now I m with perticular client who first completly works on excel and then share those requirements with us in excel ..I just started to understand or say learn excel and at the very first site I got this channel which is completly helpful...looking forward for more conceptual videos and also if you can teach us advanced functions in excel then I am happy to join !!

Nic trick sir ❤❤❤❤

Bahot shaandar sir. Bahot pasand aaya mujhe. Sir ek sawal tha ki ye doller sign k baad itne jyada space k baad value q populate ho rakhi he

Osum🙏 Thanks sir

U r explaining v good but ur question r very difficilt

Hi I am learning excel from 3 months by myself and the channel which I was watching earlier was chandoo ( if you know who is he then yes ) now I realised I should have watch ur videos first now coming to query Why didn't we direvtly writer "

Bahut top h

Hello, As you used EOM function, how can we do it for end of week ?

Keep it up sir. Vba require

sir can i do this with datevalue formula pls answer

fantasitc

Sir ji what is the easy way to learn excel conceptual .. should i learn any basic programming? I have been using sap all the time where i dont use much excel . Recently realised that I have to learn excel for my accounting work where i can easily use most of the easy functions however i am not able to think conceptually the way you have showed in the last example, it seems easy when i see your video however i doubt whether i can think the way you think . How to build the concept in Excel..

Sir ji aap ka har video pasand hai aur like tho zaroor bantha hai in advance .. last wala example thoda hard hai .. Sir ji aur bhi kuch easy example bathai ye na please.. logic clear nahi ho paya.. thank you .

Sir please make a video on “ to find out MTD of given month for year 2022 vs 2023 using sumifs”

hi, if my data is in a separate workbook, then I am unable to get SUMIFS. does the function work in the same workbook?

I have multiple condition for sumifs e.g values (+invoice -Crecit note-payment-adjustment), I want to formulation in single way without cell selection. pls advice.

Mashallah

Just wowwwwwwwww... from where can i download the sheet in which you are performing?

Awesome explanations sir i have a one doubt aapne jo ending me freez ka bataya vo kaise krna h

Hello Sir, Can we use "Text" Function in Sumif?

👍👍👍

Sir please tell me jo app Apr 2019,may 2019 text me likhe hai

❤️

sir i have question that is why i use > or < or = into the inverted commas in sumif and sumifs function bt the another thing is in sumproduct function do not use > < or = into the inverted commas.what is the reason behind it.which function i use inverted commas where not.plz explain sir.

Sir samjh me yo agaya.. Lekin criteria apne pehle product ko ku liya. Month ko ku nahii

Sir may AP ka friend ho AP ki video like krta ho AP cube ka formula btay may Pakistan say ho plz reply

Pl.do it by sumproduct function pl sir

Bahot hard tha ye . Confusion hi confusion 😁

Sir Macro ki video bhi daliye..i need this

One request to you , the examples you take when the table is small we can create by ourselves but some video their are Examples which are about 1000 records which must be really taken no doubt about that ,if possible can you share the excel sheet of the examples where records are 1000 or above in the description or any another way , please.

Nice Sir, Sir i want you solve my query is, Sales person same but route is more of 2 in vertical, but date is horizontal with datewise sales amount & products in different array. how i find different date wise sum of sales person amount? please make a video these type question . i wait .......

Aap kuch exercises bhi bata dete khud e karne ke liye to or acchi practice ho jati .

How to possible we use sumif function but this sum value automatically change with filter

AAP ITNE tech friendly insaan hai fir practice sheets ki google drive ese kyu thama di students ko ki khud dhunde konsi video ka excel kahan pe.

Pl sir how it canbe done by sumproduct pl do it

Sir, pls solve one cell 1+5 sum ki vabe hobe ????

Thank you...and you explain with a beautiful smile. Keep smiling.