Thanks Chris. I always wondered what's the difference between 1 and 101, must be something, no ? Also, I use ALT + DOWN ARROW for expanding a dropdown but glad to see that it works here as well... EDIT : 1 vs. 101 will be addressed in your next video, looking forward
Do you know how to manually hide rows? Right-click and hide. Here is an easy screenshot. With the Subtotal function 9 and 109 are sum. 109 will not show manually hidden rows. drive.google.com/file/d/1HLy9LjG3LplSVqKPwv1j4C0iOShZu7ez/view?usp=drivesdk
How do you subtotal based on criteria (without filtering)? Say you want to find the total from GA when Dept is training? I want to add up two different subtotals and find their difference. I need formulas for this since filtering would take too long.
Really clear instruction! Love it!
Thanks, Allison.
Thanks Chris. I always wondered what's the difference between 1 and 101, must be something, no ? Also, I use ALT + DOWN ARROW for expanding a dropdown but glad to see that it works here as well...
EDIT : 1 vs. 101 will be addressed in your next video, looking forward
Do you know how to manually hide rows? Right-click and hide. Here is an easy screenshot. With the Subtotal function 9 and 109 are sum. 109 will not show manually hidden rows. drive.google.com/file/d/1HLy9LjG3LplSVqKPwv1j4C0iOShZu7ez/view?usp=drivesdk
@@ChrisMenardTraining That picture is gold, Thank you, sir 👍🏻...
How do you subtotal based on criteria (without filtering)? Say you want to find the total from GA when Dept is training? I want to add up two different subtotals and find their difference. I need formulas for this since filtering would take too long.
Use SUMIFS.
How do you calculate the Median from the filtered list?
And then the question is ... what if you want sums of rows that are filtered and you want to KEEP that sum static while filtering.
love the clear instructions. just too bad it doesn't fucking work for me anyways