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.
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 👌👌👌👌
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.
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.
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Thank u !!
vary nice
शराब बहुत बढ़िया पढ़ाते हैं सर नमस्ते सर राम राम सर थैंक यू धन्यवाद जय माता दी जाए
😂
Wah Deepak Sir wah kya Kamal ka formula sikhaya aap ne
Subtotal bahut hi asan tarike se bataya aapne. Thanx👌👌👌👌👌
🤗🤗🤗😊😊😊
SuperB video thank you for making this helpful video.
Great Sir....Aaj se aap mere Online Computer Guru ho😘😘😘😘😘
Deepak Sir,
एक दम झकास | ; )
Sir aap bahut best padhate hey ❤❤❤
Thank you so much sir ❤❤❤
Tahnk you sir aapne bahut acche se sikhaya.
Very Nice and easy to understand way explained.
Thank You Sir...
Bahot Badhiya Formuliya bataya aapne.
😇
Wah wah....bahut badiya
Uh are grt sir mai sbhi ko appka hi suggestion deta hu ....
😊😊
Its very very important and useful formula. Thanks a lot.
very useful sir thanks for sharing
Nice sir very useful formula.
Am@zing Formula sir g...
Very useful...🤝👍🏻
🤗
Very useful video sir thanks
Helpful video for everyone. Thanq Boss.
Thank you so much 🙏
Such a nyc video bhot kuch sikhne ko mila thanks for sharing this video.....
Alt +
All your videos are useful...keep going
Really good understanding
Very nice and thanks sir
nice information thanks for sharing
Thank you Excellent Topic. Our Banaiye.
Very Very useful video..thanx sir 👍
Sir, Very Nice, Great, Superb,
Thanks Sir
😊
Awesome video hai sir... 👌👌
Aapke samjhane ka tarika har TH-camr se different hai...
Aur aapka sound bhi bahut acha hai.... 😎
😊
लई भारी
Bhoot acha lagaa bahi
😊
I like your tutorial very much. thank you
Very use full
Excellent, Sir.
Thanks.😄😄😄
I am very impressed to know subtotal formula. Thank you sir.
Very nice Video
Very Nice.
Namaskar sirji
Thanks
Exlent video
Superrrrrrrrrrrrrrrrrrr
Gud job sir 👍👍👍
Deepak bhai... Thank you so much.. Your videos are very helpful.. God bless you
Great....
Very nice vidieo. TX
It always help my daily basis work.
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.
Very useful video
🤗🤗
Very nice
I like your video
Good
Thanks for update knowledge
😊
मस्त था सर
Sir muze wahi attendance sheet mai work next month mai apne date ko kese rakhu
Nice video lekin aap sir eployee salary sheet banaye
Very nice video
😊
Very useful
😊
Thanks sir very good
😊
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
👌👌👌👌
😊😊❤️❤️❤️👍👍👍👍
thank u very much
😊
Good Teaching
Sum k liye to 9 hy agr minus ya mutuply krna hoga us k lite kya figure hoga?
Wow, sir
It's amazing 👍thank you. Please ese aur bhi videos banate rahiye mujhe computer ke bare me bahut kuchh knowledge rakhna h.!
Nice Sir
Really useful
Thanx.
Love The Video 👌👌👌
EXCELLENT VI
😊
really good
😊😊
Mja agaya sirji
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.
good slide
Nice info 👍
I have a Question...agar hum iski ek main sheet banayein to kya yeh total waha Trf ho jayega...
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.
sir item type bahut jyada hai, kaun se formula se item ka goshwara niklega.
Super
you are best.
nice, thanks
Agar sorting kare to 1,2,3,4...no ki position change hogi ki niii
subtotal formula ke jaisa hi cout ke liye formula hai kya
Sir subtotal ka or advanced video banavo jo hame useful ho thanks nice video 👍
🤗👍👍👍
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
nice work
New Information Partner. #Success555
Nice video ji
Eid mubarak
Nice video.
Awesome …!!!!
Wow good use of subtotal
😊
🔥🔥
jaise main subtotal formula me filter karta hu to total bata deta hai waise hai agar count jan na hai to kaise kareenge
Good
Great sir
Thanks
Counta wale me jb hm filter krte hain to tu dusre item ka ek data last me aa jata hai kya kru
Sir bina conditional formatting use kiye specific cell ka colour formula se change kaise karein 🙏🙏 please help me sir
Hi Deepak, Do you take personal excel class ?
pivot tabile sa same kam karsakte ha ?
Sir ap excel ki best prepration karate ho but. But vedio thoda lamba ho jata hai. Please ap vedio ki duration thoda kam kare.
🤗
Very useful video sir
Sir Please make videos on Mail merge of Ms word.
Thoda sa wait kr lo dear 🤗
Sir last me sl no wise subtotal nikalne me c3:c3 formula kiu lagaya ...ssmajme nhi aya. Wo jara explain kar de.
Nice video sir. Please upload a video in the topic of relationship privot table
How to lock some column and row not editable please tell me