The Subtotal Function For Excel Tables Total Row

Hey Jon... I'm a jazzed subscriber! Well done man. Quick Q... how do i add a more completed COUNTIFS formula in the TOTALs row in a TABLE that will automatically recalc when the filter is used in the Table. Example... Subtotal(103,[Status]="Bob").... obviously this doesn't work... but i think you get the idea I'm going for

Thanks for good information.

Thank you!❤

OH I WAS USING 103 INSTEAD OF 109 as a function. Ugh. The other tutorial led me astray

Excellent Knowledge Transfer!

Hi John, great video. Been working in excel 17 yrs still learning new tricks like the ones shown here. Thanks for the tutorials, already helping me shorten 4 hour reports down to 45 mins.

THANKS! I KNOW THIS VIDEO IS 2 YEARS OLD. I REALLY APPRECIATE YOUR EXPLANATION OF SUBTOTA;S (FOR MY SELF TRAINING). -TED

I appreciate the instruction, but man, using Excel feels like going back in time 40 years.
It's so archaic, creaky and obviously designed by engineers. It's powerful, but awful to use.
Any experienced software engineer these days would scream at the idea of using hard-coded numbers for function names.

John- Could you show how to create subtotals by region- i.e. a subtotal each time the data in the region cell changes

Really great Sir. I was looking for this function of subtotals of only the visible cells for quite some time, and yes, you have guided me through and through. Thanks a lot. My other question is the Video speaks only of the formatted sheets. Can you please let me know how to have the formula written in respect of sheets which are not formatted ?. Thank you in advance. Looking forward to hearing from you. With regards, Jagadeesh Bharadwaj

Why is it when using the Subtotal 9 or 109 and I filter to hide rows; the total does not change until I place my cursor in the Total field and hit F2 then enter?

Very good explanation 🤝

how is done in office 365?

super video thanks

How do I total up an Excel shopping list spreadsheet for the year?.

Can I use Subtotal to add time? I changed the column data type to time but the subtotal function won’t add the time.

I don't have the design bar

Hello Sir!
Great grip whenever i watch your conceptual videos and i have a query with you so please clear it
Query _ Sum( "2", "3") is possible to get the result but i make any cell of range as text on the numbers and apply the sum function why i don't get the result , i get the result 0 why !
please clear me this phenomenon of the excel platform
thanks and regard
Arif Safi ( from India)

Hello Sir!
Great grip whenever i watch your conceptual videos and i have a query with you so please clear it
Query _ Sum( "2", "3") is possible to get the result but i make any cell of range as text on the numbers and apply the sum function why i don't get the result , i get the result 0 why !
please clear me this phenomenon of the excel platform
thanks and regard
Arif Safi ( from India)

Thanks

Fantastic. Subscribed 👍

You are amazing

thanks John for this new video!!

like it Jon... thanks a lot.

Very informative. Thanks

This is amazing! Thanks for the clear, concise, and easy instructional video.

Plz make video on..... How to create price vlookup for 1 product with multiple packaging types and charges...... Thanks

The subtotal function is great. Thanks

Excellent jon pls share me one cell all subtotal formulas

Thanks!

Another great bunch of tips. Wondering how you drew the orange box in the video?

Hi John.. great tip.. thanks for sharing. Not so much for tables, but SUBTOTAL is also great because it ignores other SUBTOTALS in the range. So, if you have a column of numbers and have interim subtotals and use SUBTOTAL for those interim calculations, for the GRAND TOTAL you can use SUBTOTAL over the whole range, including the interim subtotals and the SUBTOTAL function will ignore the values presented by the SUBTOTAL functions in the range. Another neat trick in that instance (learned from Bob Umlas) is to do a SUM() over the range that has the interim SUBS and divide by 2. Looking forward to your next video on the SUBTOTAL function. As always, great lessons, tips and insights from your channel and web site. Thumbs up!!

Thank you for this video!

As always, I can learn easily from these videos and often find features exist that I was not aware of.

Thank you very much Jon .. I always watch your videos and gonna watch all of it.. its like a homework for me :)

Brother thank you so much...

Love the Alt +down arrow trick! Looking forwards to the next video:)

Alt-DownArrow. New one on me - excellent!!

Thanks Mr. J.....it's really useful

Thanks for the video. It was very useful information 👍

Hey John, I need you help. I got a master list and I have to label based on multiple criteria. For example, I want to label 2i for data that has 4 criteria. I don’t how to explain this. I hope that you can guide me

Great Explanation..Thank You Jon :)

You're great as always. Thx!