Multi Level SUBTOTAL in Excel | How to Create Nested Subtotal in Excel

[@shahidcpwd]

Sir I really appreciate ur effort to help people understand the excel tricks/formulas... Huge respect👍👍👍

[@sandeepaswal8944]

Sir You are an exceptionally clear teacher. Thank you so much for creating a teaching piece that is truly comprehensive and includes all learning types. I really loved this video, everything is explained in detail and in a simple way so even beginners can fully understand the formula.

[@Innozant]

Thanks Sandeep for such a wonderful commnent and appreciate my work.We always try hard to deliver best and easy to understand Content.Keep Learning ,Share and Support 🙏

[@hemantkarangutkar6169]

Of all the Excel channels, your channel is the best for learning Excel. (All problem one solution) Maine aaj bahut you tube video dekhe per kisi per comment nahi kiya ye mera first comment hai jo mare ko karna pada....Such me aap great sikhate ho....

[@Innozant]

Thanks Hemant Ji,🙏❤️Aapke ye word mere liye gift se Kam Nahin hai..Meri humesha koshish hogi ki behtar content,easy to understand leke aau..jisse apke life me value add ho aur life me aap aage jayen Apne goal ke aur najdeek.Have a wonderful career ahead.🙏❤️

[@vishalbhati912]

Bahot badiya sir. 3 layer k baad bhi layer hoti he ye nhi pata tha mujhe. Aapne toh pura subtotal ka chapter hi khol diya. Dhanyawad

[@Innozant]

Thanks Bhati Ji .Happy learning ..God bless you

[@tapasyajha7183]

Really sir you are amazing ❤✨ and your teaching method and efforts really appreciable thankyou for this great and helpful content ❤

[@Innozant]

Thanks..Keep growing

[@tapasyajha7183]

@@Innozant thankyou sir ♥️

[@shaalam2096]

Sir mera dil bol rha hai app ek din U tube p sabse jayda subscriber rhe ge. really bhot accha samjate hai mai daily learning ka rha hu step by step daily apni life value add kar rha hu.Apke liye dil se dua.

[@Innozant]

Oh thanks a lot Alam aap log sath denge do kya possible Nahi hai iss duniya me🙂♥️🙏bass support karte rahiye ham bhi Aapke liye behtareen content laate rahenge

[@VinayakSMahajan]

Sir pahale , pruduct fir sales representative 😂 kitne achhe se clear samjhaya aapne.. thank you so much 🙏

[@RA-rh5lb]

Bahut badiya Sir ji.. I never worked on multiple sort or subtotal . Good to learn new stuff.

[@adnanulislam4808]

good and very professional way of teaching, thanks for posting good educational videos

[@Innozant]

Thanks Adnan.Happy learning ❤️

[@atiqrehman1223]

excellent teacher

[@iqbalalam9656]

The way to explain is awesome 👌 👏 That's why I watch only your videos.. So appreciated

[@jyotiranjan157]

Best teacher

[@shaileshkumar-qf6bd]

Highly respected sir thank you so much❤

[@RahulYadav-vs2wd]

EKDAM SAHI KIYA H SIR AAPNEY.. kYUNKI AGAR PAHLEY PRODUCT KE END MEE KARENGEY TU EK PRODUCT BAHUT SARE SARESPERSON KE UNDER HOGA. kIYA ME SAHI HU.

[@RahulYadav-vs2wd]

Sorry mee galat tha. Pahley Salesperon aur uskey baad product sort karengey. Uskey baad salersperson ke end aur uskey baad product ke end me karenge. Kiya ab sahi h.

[@binoorsoman7366]

Amazing teacher

[@pramodbhavsar4488]

Sir very nice complete Idea of nested subtotal in excel I know advance knowledge about subtotal thank you sir

[@Innozant]

Thanks Pramod Ji..Have nice day.tc

[@prakashchordia3899]

excellent of multi level sub total. it's very useful for MIS.

[@Innozant]

Thanks Prakash ji.Keeep learning 👍

[@AlimKhan-bl5sh]

Sir discription me jo aap link dete ho.. Prectice k liya ya.. Jo bhi question dete ho usko excel sheet me kese lekar ate wahi same question ko.. Plzz bataiyega zaroor

[@amandeepbadgujjar7096]

Hii sir apki videos bohot achi h, or apke samjha ne ka tarika bhi unique h, mere sare concept ache se clear ho rahe h thank you sir, sir mera ek question h ki me practice worksheet download nhi kar pa Raha hu plz provide karade😇😇😇

[@Innozant]

Thanks. Already link diya hua ha8 video description me direct download krne ka

[@addychuhadry1889]

Sir! You are great teacher

[@Innozant]

Thanks dear👍❤️

[@shrikantbadge3978]

Amazing sir thank you

[@gudipatisaideep5030]

Kirak sir..maza ayega

[@RahulYadav-vs2wd]

Bro kis video mee iska solution h ju aapney last mee question diya h karney ke liye. pls bata dey.

[@hemgandhi8087]

Thankx Sir🙏🙏🙏

[@soubrintika2004]

Sir, my question is, how to paste the data summary with the link, I mean, if I change any data, that will reflect on the summary.

[@shaikjaveed3934]

Bahout hi clear and nice explanation sir ji learning a lot from @innozant.

[@Innozant]

Thanks Shaik Javeed sahab

[@matthew21316]

you are the best sir🙏

[@Innozant]

Thanks dear, ❤️

[@saurabhpriyadarshi4620]

Thank you very much for new content... I am happy to share my view in just two day of watching your tutorial.. You deserve more subscriber than this as your teaching technique is just wao.... I have been watching different channel for excel tutorial and accidentally came to your page .. iam confidently saying that you're better than other mentors..Just loved your content, and method... Love and respect from my side...💓

[@Innozant]

Thanks for your wonderful and valuable appreciation Saurabh Ji.Recommend your to start your Learning Journey from Playlist Basic Excel followed with Asvanced..Video in Sequence Playlist are available in video description

[@imran-yb9kw]

Conceptual study❤

[@hemgandhi8087]

Thank You

[@khalidmajeed2886]

SIR,ZABARDAST------

[@Innozant]

Thanks Khalid Majeed Sahab

[@anirbanmukherjee2590]

Sir your content is superb clearing.. I am your follower from the first day you lauch this channel. Sir it would be help is if bring the VBA series I want to learn VBA from you.

[@Innozant]

Thy Mukherjee Sahab for such a valuable and wonderful feedback.It will take time but surely you mag able to watch Power BI,SQL and VBA series step by step on your Innozant Channel.

[@deshraj2110]

Very very useful thank you sir

[@Innozant]

Thanks dear

[@hemantgusain1260]

Thanks you sir.

[@Innozant]

Thanks Hemant ❤️🙏

[@atiqrehman1223]

great work

[@satishojha6240]

Ok sir I try it thanku very much good night sir

[@Innozant]

Good..Good Night

[@RA-rh5lb]

Sir shall I have the practice work file which you have stated in the video. I couldnt find it in the link. Thanks in advance

[@sricharanmalik9117]

Namaste sir, mera data multiple column wise sort nahi ho raha hai. 2016 version Mein. Aur ye kaise hoga please bataye sir

[@artiverma5122]

Beautiful

[@pradeepkumarpotnuru2856]

ThanQ for the efforts sir. You are amazing 🙏🏽

[@Innozant]

Thanks Pradeep Ji

[@indianpigeon3680]

Bhai Power Bi ke interview questions ki video banao

[@kinghundred]

very good sir

[@sarthakbhagu707]

Great sirji thanks

[@Innozant]

Thanks Sarthak ❤️gm

[@ChandanKumar-gp8zw]

Thanks sir

[@neerajsingh-oz5od]

Sir esska solution ka mile ga...You are great sir..

[@Innozant]

Thanks 🙏❤️

[@soniasandhu4944]

Great sir thank youuuuu

[@Innozant]

Thanks Sonia..Happy Learning.Gn❤️🙏

[@hemantsaraswatgamerbhai2552]

Siri skka solution kya hai?

[@RajatKapoor559]

hello sir , i can't find that homework questions that you have given us in this class , can't see on your drive under "excel substotal ttc and data validation". please help :(

[@Innozant]

Assignment master link is given in video description

[@ankitavishwakarma3895]

sir, mere m subtotal ka option inactive ho jata h data sort krne k bad....pls help...

[@durgarao1991]

Super

[@neuaryanvlogs5172]

amazing ....

[@sitaramkohli9549]

Sir you are amezing I want learn bi and SQL sir would you please help me how can I join your course's

[@Innozant]

Sure ,You may join our Live classroom tra for the same.❤️🙏

[@tjr1421]

Sir woh home work qts ka solution do na please. Mene try kiya hai but verify karna hai🙏

[@sadhanamishra6416]

क्या बात क्या बात .....

[@Innozant]

God bles you.❤️❤️🙏🙏👍

[@mahaboobhossain5076]

Nice vijan

[@Innozant]

Thanks Dear🙏❤️

[@ShankarKumar-pu4uo]

Sir how to calculate grand total of all groups total , group total can be more than ten or twenty. I need it dynamic

[@Innozant]

Again use subtotal or aggregate

[@L.mkidifrentlife1435]

Nice sir ji

[@Innozant]

Thanks Dolly

[@vivekmusafir4492]

I want similar stuff for unique count as well...what I mean is, whenever any particular name is selected through filter unique count of associated particular field pertaining to that name should be updated...I used sumproduct and countif..but that gives unique count of overall data... whenever any name is selected total of unique values remain same...plz. help...

[@muhammadajmal6887]

=SUBTOTAL(function_num, ref1, [ref2], [ref3], ...) Sir Ji! What about these optional argument [ref2], [ref3], ... can آپ elaborate for us. Thank you dil se.

[@Kingx7565]

Sir we can do this easily with Pivot Table

[@Innozant]

offcourse we can do it using pivot.❤❤

[@birbaldoot]

अगर मैं सब टोटल को लास्ट वाले कॉलम में शो करना चाहूं तो कैसे करेंगे

[@dram3281]

good video

[@Innozant]

Thanks Ram🙏❤️

[@rahulkashyap2704]

This example is not downloading What will I can do download it ??

[@Innozant]

You may download assignment master folder direct line no given in video description

[@tejpalsain1507]

Thanks sir. File download nhi ho rhi he.

[@msexcelgooglesheet374]

drive.google.com/file/d/1W0IcL4ZkG6nXeOMX-3AQvAIX7hD2zArq/view plz, Click on the above link you will get the file and it is working. Keep Learning ...

[@thegourav_2.0]

SUBTOTAL Shortcut Key For MAC

[@msexcelgooglesheet374]

First Comment 😁.

[@Innozant]

Oh.. Thanks ♥️👍🙏

[@ishutiwari5567]

sir, is there any solution to undo sorting? every time when i sort the data,im not able to undo the sorting. ctrl Z is not working in this case. what can i do in this situation if i have saved the file?

[@Innozant]

You cannot undo the sort after saving. The best to do before sorting, is to add an ID column with numbers running from 1. Then if you want to restore your sort, you can then sort on this column

[@ishutiwari5567]

@@Innozant ok sir g thank you 🙏😊 ese hi same problem advance filter me jb filter at another place krte h tb bhi ati h.

[@Innozant]

Filter on another sheet Ka step Maine adv filter me seekhaya hai dekhna use aap..pehle active cursor his sheet par Hoga output whin aayega sirf.ok.

[@ishutiwari5567]

@@Innozant no sir, mene vo nhi kha.voto mujhe ata h.mene bola tha ki advance filter me bhi undo(ctrl+z) nhi hota.😊

[@Innozant]

Under the data ribbon 2nd icon above the advanced filter there is a clear icon.That will take care of it or click o. Advanced and reset the criteria range.♥️

[@zohaibmemon7766]

Sub Total k formula k illawa sub total kaise kr skty hain...

[@Innozant]

Goto special-blank

[@zohaibmemon7766]

@@Innozant how

[@zohaibmemon7766]

@@Innozant please any video related to my question...

[@zohaibmemon7766]

@@Innozant this video is not fulfil the requirements.... Id. Amount. Subtotal 123. 150 123. 150 123. 200. 500 124. 150 124. 300 124. 150. 600 I want to calculate like this...

[@sharmashivan8379]

Sir, kindly give English Subtitles for your videos.. It'll be more helpful.

[@Innozant]

Ok..will try

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@shristhiecommercesolutions]

ISKE LAST DO QUESTIONS KA SOLUTIONS KON SE VIDEO MEIN HAI??

[@Innozant]

Usi series me hoga aase Shrishthi..nhi mile to btana..will guide you.

[@shristhiecommercesolutions]

@@Innozant ok sir

[@abhijeetbose2236]

My excel is lagging when I am using subtotal function

[@Innozant]

?

[@tasilama7005]

👍👍👍

[@Ghumantug7]

FILE DOWNLOAD NAHI HO RAHI H SIR JI

[@Innozant]

Assignment master jo main link hai wahan se download kar lien..direct link abhi broken ho gya hai isliye maine master link de diya hai

[@Ghumantug7]

@@Innozant Thank You Sir Ji

[@Ghumantug7]

@@Innozant abhi esa koi din nahi jaata ki me aapki video na dekhu kaafi sikhne ko milta h sir Thank You Very Much

[@Innozant]

@@Ghumantug7 great...God bless you..Have a wonderful career ahead ♥️

[@teachingforstudents777]

Sir I have need a student regarding due for month amt rec'd revenue rec'd total revenue due and receive students ledger wise pls send 🙏

[@Innozant]

Sheet send kijiye aise aapki query nhi aara hai smjh kya puchna chahte h aap

[@paras5861]

Sir Telegram se send nahi ho rahi h pls share email id to main bheju aapko

[@Innozant]

KZbin about section me email id diya gya h

[@paras5861]

@@Innozant Guruji! Maine apko bhej diya h. Paras k naam se & Guruji you are the best

[@neerajsingh-oz5od]

Sir Solution

[@Innozant]

Which solution dear🙏

[@neerajsingh-oz5od]

@@Innozant ess assignment ka jo diya tha apne

[@vijaykumarjain3222]

Very nice sir Sir I want to in tally I have group name call Bajaj ins. In bajaj ins. Two ledger 1.bajaj 10-11 debit ledger and 2. Bajaj ftr credit ledger But when doing pvoit filter, showing only in ledger I want your help how to slove Or sir u can send me your contact no. For call.

[@Innozant]

Kidnly share your workhseet 🙏❤️

[@hemantkumarbharti6359]

Sir telegram I'd kya hai apki

[@Innozant]

@innozantofficial

[@atiqrehman1223]

excellent teacher

[@shrikantbadge3978]

Thank you

[@artiverma5122]

Beautiful

[@gauravbhatia7987]

Thanks sir

[@Innozant]

❤️🙂