Calculating Subtotals in Excel

In this quick Microsoft Excel tutorial video, learn two useful methods to calculate subtotals in Excel.
To see the full blog article that this video came from, go here: ➡️www.simonsezit...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit...
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[@SimonSezIT]

We have additional free Microsoft Excel training here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html and here 👉 th-cam.com/play/PLzj7TwUeMQ3isgpmQEWFwWqFZ95Ih-AhA.html and Excel Tips and Tricks 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
🔥Check out our FREE 300+ hour training course playlist here 👉th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html

[@encapturedbywiredesignsmar5278]

Firstly, I am completely new at excel and have been watching your channel for hours. I have learned a lot. Thank you for all you do. My question is with the subtotal, will it continue to subtotal if you add to the table? I have been trying to get it to work on a sheet I am working on but I get a pop up about for some reason saying that rows will fall off the sheet. I don't know what I have done wrong.

[@EmmanuelMwami]

thanx

[@nirmalsurendranmenon7049]

When I use subtotal function to count, it's taking the values of the formulas of the cell as well and giving the out out. How to avoid that

[@Salman-Ahmad]

Life Savoir.

[@SimonSezIT]

Glad it was helpful!

[@Ang-x2m]

how do you subtotal by month using categories?