Calculating Subtotals in Excel

preview_player
Показать описание
In this quick Microsoft Excel tutorial video, learn two useful methods to calculate subtotals in Excel.

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Рекомендации по теме
Комментарии
Автор

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.

encapturedbywiredesignsmar
Автор

how do you subtotal by month using categories?

Ang-xm
Автор

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

nirmalsurendranmenon