How To Use The Subtotal Feature And Subtotal Function In Excel

Thank you, you have saved me an afternoon.🙂

I have been using the subtotal feature for a while but I have a question. Is there a way to show the information from the Price row in the subtotal row as it is currently blank. I have been dragging the cell information but I wonder if there is an easier way. Thanks for your videos!

Thank you!!! You are so good at explaining this in a way even I can easily follow.

Really Great!

This is very detailed and helpful. I can totally shorten my time doing my work. More power!

Is there a way to chart multiple subtotal amounts in a pie chart showing as a percentage of the grand total, ie Product A is 30 % of the grand total, Product B is 15% of the grand total, etc but showing this in a pie chart??

Fantastic lecture on subtotal.
Thanks

What if I want to keep the price in the subtotal row? How to do that?

This was very helpful for someone who is not too savvy with Excel functions- Thanks!

pls show subtotal from negative positive numbers at a time. I badly need it.

Very nice 👌 thank you brother

Hi Jon,
Brilliant video, I have two questions and if you can help me will be appreciated.
1. How did you create the drop downs on the left of your screen.
2. If there is a number that is not part of the subtotal then how do we stop it from being added into the subtotal range at the end. In between my subtotals i have number and it adds that number to the main subtotal at the end.
Regards,

Thanks :)

Awesome, thanks!

Thank You so much.

hi Thank's

I’m trying to have excel see a list of numbers and number them in order 1-27 which function would be best?

sir why is it that the sub total product C total is not included in the grand total calculation , just want to know the reason.Thanks

Excellent explanation! Thank you!

The best explanation by far!! Thank you! I look like a genius now!

Thank youuu!!

Thank you for your clear explanation 👍🤝

This is terrific stuff. Thanks!

Hi Could you please help me to resolve the following:
Columns : Products, Price, Qty sold

I want to sum(price *qty sold) as well as subtotal in case the filter is applied

Eg.
=Subtotal(9,Sum(B1:B10*C1:C10))

Thanks

Hello, thanks for this feature
Do you know how to do the same in Sheet please ? which add new rows like in Excel according to column

Thanks by advance

The biggest problem with th Subtotal feature it does not work with Excel Tables and the SUBTOTAL function only works as a a Total Row. That fact needs to be explicitly in any video on the Suntotal.

Great vid! If you have a table of data and one of the columns has times in it. Is there a way to create a Subtotal for the column of time (ex. idle time) and have it sum that data?

thank you!!

Hi Jon, what if the Products were not sorted i.e. all Product A listed together, would the subtotal function still work?

This video helped me learn more about excel, for own knowledge and for my class. You have nice teeth.

I tried subtotal in a dataset with country and total income but it gave the same country where then once. Probably because there are spaces and therefore sees same countries as diff categories?

OH MY GOSH! Thank you so much!! I've been having a problem with the hidden rows being part of the sum.

You save me with this video, I need to tell you this, I was trying to obtain subtotal; my first language is Spanish so I sought for instructions in Spanish, but I'm using an excel that's all in English; this laptop was given to me by an American company well, anyway, In Spanish instead of a coma* is this sign ; so I was getting frustrated 'cause I was not getting the formula, if it wasn't for you I wouldn't , thanks a lot!

Jon, your videos are awesome. Thank you so much!

thanks for the video, can you use the subtotal with a condition for exambple sumif?

Looking to use TRIMMEAN calculation in SUBTOTAL function. Did I just discover the first thing that excel cannot do?

woooow what the heck? i been using excel for years and i just noticed the subtotal feature....

Thank you Jon, I appreciate your comprehensive explanations.
Keep it up!!

Is there any way to subtotal and get a sales total but then manipulate other columns data that are strings? So it's a list of a customers orders, and I get the subtotal that's fine, but say another column has strings that could match or be diff..is there a way to make the subtotals show like specific data? (Like if the rows subtotaling included the words Personal it could say "Personal" in the subtotal?

Thank you

excellent

this was super helpful, you saved my life. thanks so much!!

is there anyway to subtotal rounded numbers? You can sum(round...) but I can't get it for subtotal

What if I want to add more data to my subtotal group. How do I refresh the subtotal groups to include the data that I just added with my currently formatted subtotal group?

Thank you very much. Very well explained and comprehensible.

Excellent video.

Thank you , helped alot.

Thanks , how to apply validation for subtotal, drop down list ?