How to use SUBTOTAL function in Excel | Hindi

How to use a SUBTOTAL function in Excel | Hindi
Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
www.excelsupers...
To watch more videos visit: www.excelsupers...
To Buy an Excel Course Pen drive visit: www.excelsupers...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

[@ExcelSuperstar]

Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20* Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ

[@priyankachourasiya9712]

Sir iss video mai dj nhi bajhe why ??

[@gopalvhagrawal]

Best channel for excel i hav ever encountered

[@surbhishah6346]

amazing.. I was not knowing this.. thank u for video and KT 🙏

[@ExcelSuperstar]

Advanced Excel Webinar v2.0 Hurry up! Book your seats now(limited seats) www.excelsuperstar.org/

[@SeniorEditor]

very nice sirji

[@malikzulfiqar8965]

you are a such genius boss salute to you keep it up to spread a knowledge for human beings

[@baigmaheboob6818]

excellent bro

[@aniruddhamehta7727]

Nice video and very good explanation as well.

[@sadikshaikh4663]

Hi, I just started watching your videos... Awesome..!

[@sureshnagwan7805]

Good video

[@harishpaldhir5915]

A very good way to clear diff of subtotal 9 and 109 😁😁😁😁🤗🤗🤗🤗🤗🤗😇😇😇😇

[@anjaneyulukodam9961]

Method your teaching is good. Thanks for your trail. Good night sir,

[@saurabhp.2246]

Please make video on Go to special, Paste special, Text to column, with line by line item of option and example. Text to column, why we do it. Delimit meaning everything

[@gautamsarkar4978]

please help me in calculation of subtotal of big data

[@gopalnath3504]

Awesome

[@francisdsouza8303]

Awesome Sir

[@sayedsohel6674]

খুব ভাল ভিডিও.....

[@sikandarbhojani23]

You are really super star!

[@AtulKumar-rm2sp]

Hii sir How to multiple invoice or multiple value calculate

[@BhupinderSingh-jj3hb]

so nice thanx

[@Criczone2712]

Sir.. i use excel 2007.. while hiding manually. I got the same answer in both 9 and 109. Why?

[@salmankasgar6070]

Thank you sir

[@kanaihyaagarwal7331]

Sir... Subtotal for manually hidden columns when we are adding, say A2:G2 with Column C & D is hidden... it not working.. Please guide me where i am wrong..??

[@ayazahmad5125]

Thanks Bhai...!!

[@shruthikumar3107]

Sir but when filtered,both 9 and 109 working as same plz explain.

[@iftikaralam1oOne]

Yes

[@anjusharma7179]

usefully knowledge

[@md.shihabuddinsabuj8766]

Can I subtract any cell value by useing subtotal?

[@updeshkumar4481]

great

[@neerajsharma-xi3vm]

Hello sir when we apply this subtotal function with filter I can get the exact figure but we un filter my data my total answer will difference in both situation please suggest.

[@khemrajrana7322]

Awesome siri

[@sachinpandav8613]

Sir 4 or 5 sheet me se one sheet delete kar di to restore kaise karen

[@anjaneyulukodam9961]

Good morning sir,

[@09shirish]

Thanks Sir, I've got a problem. please help me i.e. In excel sheet, is there any command for pagewise subtotal and total (there is no any filter or any shorting) pl help sir

[@Spdabhade2011]

pl. explain subtotal with counif

[@md.shihabuddinsabuj8766]

How can i use subtotal in my ledger

[@maxcomputer8]

nice videos

[@manishsinha9612]

sir kya koi aisa fourmula hai jo har page ke last me autometic sum kar de

[@tulsidasjamnani9455]

Thnx sir...

[@skdaveskdave9798]

I used in subtotal 109.in my excel set bank pass book a/c db ,cr and balance already set up according to formula, above title list db column done subtotal with 109,similarly subtotal Credit and then above title balance db-Cr done magic be happen that accurately match end Balance,After few days problem create that at balance formula is shows correct form but dragging numbers does not active , while step to step press enter then it intimate number , what the matter dragging process faill

[@drankusharmathewolverine]

Nice

[@minkigupta1198]

sir ji aap ki video mst hai pr advance wale video upload kijiye

[@raghavanand7476]

how to divide by using subtotal

[@vinodkumarjaiswal2428]

sir muhje aisa formula bataye jime keval subtotal ko sum karna hai

[@rinkuansari2189]

sir excell may page print kaishy banay

[@aryanved6265]

sir price,disc,effective,nominal function kebhi hindi tutorial banaye

[@nicelcomputereducationathg1936]

Sir how to use number +2 Pleased vedio

[@MrHmm-cv6gs]

when i tried this ,, no difference 9, and 109 worked same... excel 2016

[@rknareda5]

Sir jab subtotal ka aage jakar ek jagah total hota hai to us cell me 0 likha aata hai . Iska kya solution hai

[@bestvidoes8205]

Sir Pivot table aur chart m month kaise laye

[@riajkhan1865]

Hlo friend Yar iske no. wise kaise dekhe

[@gulmuhammad7298]

sir data thora liya kran pehla phr zyada la k smjha dia krain

[@govindsingh9707]

Sir asa Ho sakta hai kya ki ham kisi file ko sam kare or o file filter m v sam Ho or filter hatane k bad v Sam huaa rhe ...mtlb sir ek bar Sam kare or us file ko agar filter laga De to jo filter huaa hai o auto Sam dikhi de

[@amriksingh4892]

Ek Formula hota hai Aggregate use jo b Row hide karoge to aggregate us value ko hide karke dikhayega aur jab wo value unhide karoge to wo usko total karke dikhayega (Amrik Singh) if do you have any problem in Excel so you can msg me on my Email-ID I will try my Best [e-mail]

[@pradhanenterprise7777]

mice vido

[@kalpeshmarvaniya9949]

Mero excel sheet me 8:30=1 karna ho hosktahe

[@puneetvij8433]

Rishabh Sir, Thats not done! I have requested a video regarding various uses og Indirect function earlier, and it hasn't been launched till now. You haven't even replied. : (

[@rinkuansari2189]

Hi..

[@sadashivattarkar3312]

SUBTOTAL(109,) FORMULA WORKS IN ROWS, BUT NOT IN COLUMN. PLZ. TELL WHICH FORMULA WORKS IN COLUMN SAME AS =SUBTOTAL(109'-------)

[@priyankachourasiya9712]

Iss video mai aap e dj nhi bajaye sir 😃😃

[@sumankumardas7621]

kabhi kabhi logo ko ek hi cheez do bar dikhta hai😁😁😂😂

[@adilhumayun125]

Very bed , you don't give to answer to anyone

[@AjayChauhan-ly9mo]

usefully knowledge

[@salmankasgar6070]

Thanks you sir