This was the best explantion/ walk through of using the subtotal formula, which was why I came here. The additional information re: filter views was very helpful. Thank you
Is there a way to have a filter view subtotal update regardless of if you are in that filter view? Maybe that was the 109 that you mentioned? I want to have a subtotal remain visible for all users regardless of filters or filter views. Thanks!
I have data I need to filter per quarter as each quarter ends. How do I add data to an already filtered sheet? Without having to refilter? For example I have employee "Tom". Each quarter I need to filter projects that he works on for email department. Then when the next quarter ends, I need to calculate that quarter's hours for email. How do I do this without having to open up a sheet for each quarter for Tom? Please help! I've gone through multiple tutorials and cannot find an answer. Thank you in advance!
Please diplay in the video function where is the second part of your video and take the habit to do it for all your videos so we can avoid loosing time. Thank you for your work.
too much at once - common excel data 'function' was - "on change of x , sub-total y " -> where x was a descriptive sorted field ( like region or category of spending ) and y was a numerical amount field ( like spending ). Executing this in Excel was 'intuitive' -sub-totals would simply be calculated and 'pop-up' where you would see them. First order of business in an introduction to google sheets should focus on this base level of functionality, rather than try to demonstrate all the workings that Sheets is capable of.
This was the best explantion/ walk through of using the subtotal formula, which was why I came here. The additional information re: filter views was very helpful. Thank you
This filter view I already know I'm going to use at work for one of my template. Thank you so much!
Super helpful and very clear explanations. Thanks a bunch!
Thanks very much, very helpful!
Thank you for the tips. I almost never use this formula's but good to know
when you turn on a filter view, I also want to sort the Brand (Nike) in the subtotal.
what the formula would be??
Makes it look easy!
Very very helpful. TY so much!
Thanks a lot, it was helpful
Great presentation!
Filter views are more easily accessed through the toolbar, on the filter icon.
Is there a way to have a filter view subtotal update regardless of if you are in that filter view? Maybe that was the 109 that you mentioned? I want to have a subtotal remain visible for all users regardless of filters or filter views. Thanks!
Thanks!!!
Great info as always!
Is it possible to create a button on a dashboard that applies a filtered view?
Thanks for the info
we miss u
Sorry, it's been a busy summer. New videos will be coming in fall.
great explanation to you sir but is it possible to place the total amount as a total row on the last line of the filtered data? thx
Good work sir 👍
I was wondering if you can make a tutorial/series on creating a google hangouts bot using app scripts
Simply classic
Thanks
I have data I need to filter per quarter as each quarter ends. How do I add data to an already filtered sheet? Without having to refilter? For example I have employee "Tom". Each quarter I need to filter projects that he works on for email department. Then when the next quarter ends, I need to calculate that quarter's hours for email. How do I do this without having to open up a sheet for each quarter for Tom? Please help! I've gone through multiple tutorials and cannot find an answer. Thank you in advance!
I'm not sure if I really understand what you need exactly, but from what I can tell you might need to use a pivot table.
Please do more videos using Array formulas ;]
Thanx.
Please diplay in the video function where is the second part of your video and take the habit to do it for all your videos so we can avoid loosing time. Thank you for your work.
Can you make video for star rating system??
🙏🏻
what's wrong with your tongue ?
you aint white or black. who the hell are you ?
too much at once - common excel data 'function' was - "on change of x , sub-total y " -> where x was a descriptive sorted
field ( like region or category of spending ) and y was a numerical amount field ( like spending ). Executing this in Excel
was 'intuitive' -sub-totals would simply be calculated and 'pop-up' where you would see them. First order of business in
an introduction to google sheets should focus on this base level of functionality, rather than try to demonstrate all
the workings that Sheets is capable of.
google sheets sucks for subtotaling.
Super helpful and very clear explanations. Thanks a bunch!