Why You Should Use Subtotal 👉 Most Ever Useful & Powerful 💪 Excel Formula ☑️

Why Subtotal Is Most Ever Useful & Powerful Formula of #Excel with continuous serial number. subtotal formula is very powerful and most ever useful formula of excel which work only on visible data. when we filter data then subtotal is best formula to make calculations on filtered visible data only. there are many functions inside subtotal such as sum count counta countif average max min etc. watch the video and this subtotal formula will work in all excel versions 2007 2010 2013 2016 2019.
#deepakeduworld
#Excel
#subtotal
#Excelmagictrick
Excel Data Tab : SubTotal Option In Detail | Best Explanation in Hindi • Excel Data Tab : SubTo...
How To Print Subtotal In Footer Of Each Page In Excel || Paging Subtotal • How To Print Subtotal ...
Download Training File drive.google.c...
if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
#excel
#subtotalformula
#DeepakEduWorld
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@likhonbasak9955]

Thank u !!

[@mdrukan8744]

vary nice

[@RahulYadav-cf1yo]

शराब बहुत बढ़िया पढ़ाते हैं सर नमस्ते सर राम राम सर थैंक यू धन्यवाद जय माता दी जाए

[@ShantiVishwakarma-gh3ry]

😂

[@MrPZAHOOR]

Wah Deepak Sir wah kya Kamal ka formula sikhaya aap ne

[@exceltech6012]

Very nice and thanks sir

[@manpritsingh7772]

Very Nice and easy to understand way explained.

[@SunilKumar-nv2zp]

SuperB video thank you for making this helpful video.

[@subhadipaditya4603]

I've used subtotal formula for serial nos in a data sheet. But when I'm using filter, every time the last line of the data sheet is coming with the filter. Kindly can you solve the problem please.

[@akkushawah7463]

Thanks you so much sir

[@zafardhansay300]

Nice sir very useful formula.

[@dakshkumar873]

Tahnk you sir aapne bahut acche se sikhaya.

[@pankajsaini50]

Great Sir....Aaj se aap mere Online Computer Guru ho😘😘😘😘😘

[@himi1509]

Thanks Sir 😀

[@omsai-qq8hn]

Very useful video sir thanks

[@dipk0286]

Bhoot acha lagaa bahi

[@DeepakEduWorld]

😊

[@vipuldce]

Wah wah....bahut badiya

[@luqmanansari6583]

Very Nice.

[@sandeepchauhan-pk8me]

Sir aap bahut best padhate hey ❤❤❤

[@Ajitmotomania46]

Thank you so much 🙏

[@hari60700]

Very nice Video

[@rashmijoshi6412]

Really good understanding

[@vaibhavbaraiya6867]

very useful sir thanks for sharing

[@ajaymody9851]

nice information thanks for sharing

[@moloybarman1237]

I like your tutorial very much. thank you

[@kamalthapa2184]

Very nice

[@mohammadsaifulislam6748]

Its very very important and useful formula. Thanks a lot.

[@pradeep595]

I like your video

[@Amit__Singh_]

Good

[@ganeshballav5652]

Thanks

[@pankajsharma9996]

Subtotal bahut hi asan tarike se bataya aapne. Thanx👌👌👌👌👌

[@DeepakEduWorld]

🤗🤗🤗😊😊😊

[@moodkn]

Great....

[@veereshkuruva2955]

Nice Sir

[@mikayeelansari]

Am@zing Formula sir g...
Very useful...🤝👍🏻

[@DeepakEduWorld]

🤗

[@vijaysinhparmar5688]

Very nice vidieo. TX

[@debukonwar795]

Very useful video

[@DeepakEduWorld]

🤗🤗

[@nitinraj4865]

Helpful video for everyone. Thanq Boss.

[@dreamworld8129]

Uh are grt sir mai sbhi ko appka hi suggestion deta hu ....

[@DeepakEduWorld]

😊😊

[@52ramiyer67]

good slide

[@kusumbala88]

Very Very useful video..thanx sir 👍

[@atulshah2235]

Sir, Very Nice, Great, Superb,
Thanks Sir

[@DeepakEduWorld]

😊

[@soumimondal6427]

Very nice video

[@DeepakEduWorld]

😊

[@naeemhaji7205]

Thank You Sir...
Bahot Badhiya Formuliya bataya aapne.

[@DeepakEduWorld]

😇

[@s.m5793]

Excellent, Sir.

[@TrUeLinEs9966]

Super

[@uttamanandarout7135]

Very useful

[@DeepakEduWorld]

😊

[@aaravchauhanshorts5300]

All your videos are useful...keep going

[@KuldeepSharma-gl1hn]

Great sir ji

[@thodaalag1642]

Very use full

[@firojansari7696]

Awesome video hai sir... 👌👌
Aapke samjhane ka tarika har RUclipsr se different hai...
Aur aapka sound bhi bahut acha hai.... 😎

[@DeepakEduWorld]

😊

[@devbaba3312]

मस्त था सर

[@devbaba3312]

Sir muze wahi attendance sheet mai work next month mai apne date ko kese rakhu

[@sabrealam6394]

Nice video lekin aap sir eployee salary sheet banaye

[@RanjitSingh-jd3qb]

really good

[@DeepakEduWorld]

😊😊

[@kiransati3508]

Gud job sir 👍👍👍

[@skjilanisk]

Thank you Excellent Topic. Our Banaiye.

[@mahaboobhossain5076]

EXCELLENT VI

[@DeepakEduWorld]

😊

[@Chefvsn004]

Deepak bhai... Thank you so much.. Your videos are very helpful.. God bless you

[@helphamesha10]

Thanks.😄😄😄

[@nasrulansari7961]

thank u very much

[@DeepakEduWorld]

😊

[@bsnlfreeepabx5850]

Good
Thanks for update knowledge

[@DeepakEduWorld]

😊

[@mukeshkale]

लई भारी

[@babuhkonameti4294]

Namaskar sirji
Thanks
Exlent video

[@zeeshan-ul-haq9263]

Sum k liye to 9 hy agr minus ya mutuply krna hoga us k lite kya figure hoga?

[@elisantedaniellulu]

Awesome!
Thank you man for sharing this.
I don't know the language you are using (apart from some English word you mentioned) but I got it all because you have simply explained it
👌👌👌👌

[@DeepakEduWorld]

😊😊❤️❤️❤️👍👍👍👍

[@mrfunny5780]

The SUM function will include filtered rows in its calculation while the SUBTOTAL function will exclude filtered data by only using the rows that remain visible after filters are applied.

[@Jai_Mata_di_222]

🔥🔥

[@Mdr232]

Mja agaya sirji

[@maheshgarde7989]

Good Teaching

[@everythingelse1440]

sir item type bahut jyada hai, kaun se formula se item ka goshwara niklega.

[@NarinderKumar-fs5pq]

Superrrrrrrrrrrrrrrrrrr

[@vijaychouhan2951]

Nice info 👍

[@shivc6697]

nice, thanks

[@shuvamdey9243]

Nice video.
But, Sir jab ma abc company filter kar raha hoo tab last row pa jo xyz company ha yo aa raha ha.
But, Sir serial number colum pa subtotal formula ma counta (3) ka formula charge karna ka bad hi asa horaha ha.
Koi vi colum sa kich vi filter karu to last wala row aa raha ha.
please help me sir.

[@kashrafali2258]

ACCHA HAI, MAGAR 300 LINE HO TO KAM NAHI KARTA, MADLAB 300 KE BAD JAB 200 LINE AATA HAI TO 300 TAK NUMBER ISA HI REH JATA HAI

[@poojasaxena5976]

Sir thoda zoom krke dikhana tha ji counta kiya tb

[@ajmalshahtravelling7088]

nice work

[@abusahma5795]

Thanks sir very good

[@DeepakEduWorld]

😊

[@adilhumayun125]

I have a Question...agar hum iski ek main sheet banayein to kya yeh total waha Trf ho jayega...

[@bikramaggarwal4900]

you are best.

[@raj3077]

nic

[@sunitasharma4532]

Such a nyc video bhot kuch sikhne ko mila thanks for sharing this video.....

[@DeepakEduWorld]

Alt +

[@shekharavade2043]

nice sir

[@sksahajahan143]

I am very impressed to know subtotal formula. Thank you sir.

[@user-gv7ft4ik4h]

subtotal formula ke jaisa hi cout ke liye formula hai kya

[@success555]

New Information Partner. #Success555

[@omkarkelshikar7484]

Sir subtotal ka or advanced video banavo jo hame useful ho thanks nice video 👍

[@DeepakEduWorld]

🤗👍👍👍

[@pardeepkashyap4381]

Nyc

[@DeepakEduWorld]

😊😊

[@mohsinazhari2869]

Nice

[@user-gv7ft4ik4h]

jaise main subtotal formula me filter karta hu to total bata deta hai waise hai agar count jan na hai to kaise kareenge

[@mohanpal13555]

make more vedio subtotal vedio sir, more example subtotal filter sir,

[@asmrindia]

Very Nice Sir
But Aapne Complete Explaination Nahi Diya. Usme Har Formula Double H. Uska Use Kse Hoga?

[@sherazrathoor8552]

Eid mubarak

[@Sagarkumar-qj3hl]

Counta wale me jb hm filter krte hain to tu dusre item ka ek data last me aa jata hai kya kru

[@DeepakSaini-lq2ps]

How to lock some column and row not editable please tell me

[@dharmendrayadav-bw2gp]

Nice video.

[@rakeshchandaliya5196]

👌

[@pawanverma7220]

Love The Video 👌👌👌

[@AjayKumar-wi9ot]

jai hind sir

[@meandmycreation453]

Sir last me sl no wise subtotal nikalne me c3:c3 formula kiu lagaya ...ssmajme nhi aya. Wo jara explain kar de.

[@paramjeet975singh3]

Agar sorting kare to 1,2,3,4...no ki position change hogi ki niii

[@rahitmukherjee3802]

pivot tabile sa same kam karsakte ha ?

[@chetantomar6487]

Awesome …!!!!

[@karthikrajgopal8627]

Nice video ji