How to use subtotal function in excel |wrong sum when user filter excel advance trick #advanceexcel

How to use subtotal function in excel |wrong sum when user filter excel advance trick #advanceexcel is video me main aapko subtotal ka use for sum of data sikhanunga kaise aap subtotal function ka use kar ke visible cells ke data ka sum kar sake hai agar aap normal sum function ka use karte hai and filter ka use karte hai to sum function hide data ko bhi sum karta hai jo filter me aapko acording to filter result nahi deta hai but agar aapko only visible data ka hi sum karna ho to aapko subtotal function ka use karna chahiye. #subtotal #subtotalfunction #advanceexcel #exceltricks #exceltips #exceladvancetutorial ---------------------------------------------------------------------------- For Business Cont :- help.excelmentor @gmail.com ---------------------------------------------------------------------------- Follow on: ----------------------------------------------------------------------------- ☑ Instagram : https://www.instagram.com/xlmentor ☑ Telegram : https://t.me/xlmentor ----------------------------------------------------------------------------- 🙏Disclaimer- Some contents are used for educational purposes under fair use. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational, or personal use tips the balance in favor of fair use. All credit for copyright materiel used in video goes to a respected owner. 🎓 ----------------------------------------------------------------------------