How to Use SUBTOTAL Function | MS Excel Malayalam
One of the most powerful function in MS Excel. In this video, you’ll learn the basics of using subtotals in Malayalam for users ; Excel 2019, Excel 2016, and Office 365.
Download file used in the video: drive.google.com/drive/folder...
The function SUBTOTAL is used to get a total of the returned values. Mainly when a tabled is filtered, the SUM function will still return the entire column total.
#SkillToSucceedbyAlfan #ExcelSUBTOTALmalayalam #ExcelSUBTOTAL
Пікірлер: 101
it's very useful, എങ്ങനെ ഒരു റിസൾട്ട് ഒട്ടും പ്രേതിഷിച്ചില്ല , Macro cheyyunnathu polundu
@rows_columns
2 жыл бұрын
😊🙏
Hi.. Sir... it's very useful class... Thank youuuu sir✨🤗
Good presentation 🙏 helpfull 🔥
Awaiting more informative videos
Awaiting for more videos.
Thank you sir
well explained .
Thanks a lot
Thanks man ❤❤❤
Hi can you please explain what's the difference between an Excel subtotal and sum function?
Thanks
Waiting for more videos.....
How to copy only the cell of the sub total of rows? i.e. north, south, west and east subtotal cells.
helpfull
same thanne Pivot Table vechum cheyyan pattile?
Highly recommended youtube channel.
@rows_columns
2 жыл бұрын
❤️
Thank you... thought excel couldn't handle such complex formulas... Best wishes 👍
@rows_columns
4 жыл бұрын
☺️👍
Sir can you plz send the data for practice ing
A good teacher.
@rows_columns
4 жыл бұрын
☺️
Last methodil subtotal cheythath remove cheyth pazhayath pole aakkan pattumo?
Thank you, bro
@rows_columns
2 жыл бұрын
Most welcome bro👍😊
Thank you
@rows_columns
Жыл бұрын
😊
Could you please sent the data for practicing 😊
Could you pls send the data for practicing
Pls sent data of this subtotal and pivot table
Informative ❤
@rows_columns
Жыл бұрын
😊
Don't know how to thank you from morning onwards i was trying aimlessly to solve a calculation . Now i resolved it because of your video. Tnx a lot. May god bless you.
@rows_columns
2 жыл бұрын
God bless you too brother❤️
Super 👍
@rows_columns
Жыл бұрын
Thank you! Cheers!
really u r super dear😍
@rows_columns
Жыл бұрын
Thank you, I am happy to hear you feel that way!
Poliyanu.....
@rows_columns
2 жыл бұрын
🙏😊
Ee function ,date il use cheyth monthly results edukkan pattuvo
can i get all your data sheets pls
good video
@rows_columns
3 жыл бұрын
Glad you enjoyed
Can you give me a sheet for practice
Ikka polii 😍
@rows_columns
3 жыл бұрын
😊
💫💫
📌To Learn Microsoft Excel in English, Click on the Below Link: kzread.info/dash/bejne/daJnj8SFdM6tfbw.html
Thanks sir I have a one request : sir kanikkunna table okke onnu boxil ittal njangalku practice cheyyan athu upayokikkamayirunnu
@rows_columns
2 жыл бұрын
Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates
Aflanka enik 1 monthly sheetl ninn chila coloumns specific ayt subtotal eyd kanikan ptuoo?? Eg(1 date select eydhal bank cash sale idhoke mari mari veranam) excel aa option indo
@rows_columns
2 жыл бұрын
Yes bro, separate video il kaanikkam😊
Alfan how to do monthwise subtotal? Is it possible in same function or different?
@rows_columns
4 жыл бұрын
Yes Brother, we can use the same function.. But only thing needs to be change is Date format (Converted to mmm-yy). It works🤝😊
Bro, I believe we can do the same with pivot table also. What do you say?
@rows_columns
2 жыл бұрын
Yes.. absolutely
Thank you...very helpful😍
@rows_columns
3 жыл бұрын
You're welcome Bro😊
Sheet therumo
Well explained. Session was really informative.👍
@rows_columns
4 жыл бұрын
🙏
@mrshabeermp
3 жыл бұрын
Simply explained very informative topic.
👍
@rows_columns
2 жыл бұрын
😊
Need sheet
ഹലോ bro എനിക്ക് ഒരു excel ഷീറ്റിൽ formulas add ചെയ്യാൻ help ചെയ്യാമൊ ?
@rows_columns
2 жыл бұрын
You can put your enquiry under below forum link. Lets share the knowledge with other :) www.rowscolumns.com/forum
in google drive, subtotal functioncode is not desplayed by default
@rows_columns
2 жыл бұрын
I didn't get your question..
എനിക്ക് തോന്നുന്നു എക്സൽ നിങ്ങളാണ് കണ്ടുപിടിച്ചതെന്ന്... Excell കണ്ടുപിച്ചവന് പോലും ഇത്ര അറിയണമെന്നില്ല 😀😀😀😀
👍 very good
Hi Alfan please send me the datas for practice
@rows_columns
4 жыл бұрын
Sent :) Pls check your inbox!
Sir, സെലക്ട് ചെയ്യുമ്പോൾ Sort മങ്ങി കാണുന്നു. ഓപ്പൺ ആകുന്നില്ല.
@rows_columns
3 жыл бұрын
How come.. can u try again....
I don't know the basics could u please help me out
@rows_columns
3 жыл бұрын
Can I have your whatsapp no pls
@nizamzam7155
3 жыл бұрын
@@rows_columns 9526008582
Alfan You explained it very simple words , could you please mail me a sample work sheet , Thanks
@rows_columns
4 жыл бұрын
Thanks for the feedback☺️ Sure ur mail id pls...
@vipinkv2050
4 жыл бұрын
vipinkv01@gmail.com
ഫിൽറ്റർ ചെയ്ത ശേഷം വിസിബിൾ സെല്ലിന്റെ തുക മാത്രം ആണോ വരുന്നത്.
@rows_columns
2 жыл бұрын
Yes😊
Sir, is it possible to send me this work sheet ...I can share my email accordingly
@rows_columns
3 жыл бұрын
Hi, you can access all my worksheet from my community tab by clicking the share drive link which I mentioned last week😊 Keep learning✨
@jpillai7920
3 жыл бұрын
@@rows_columns thank you sir
Thanks
@rows_columns
2 жыл бұрын
Welcome
ഹലോ bro എനിക്ക് ഒരു excel ഷീറ്റിൽ formulas add ചെയ്യാൻ help ചെയ്യാമൊ ?
@rows_columns
2 жыл бұрын
You can put your enquiry under below forum link. Lets share the knowledge with other :) www.rowscolumns.com/forum