# Get instant live expert help on I need help with excel subtotal 9

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

When using the function 'subtotal 9' the data is filtered and once I change the filter the subtotal changes too. I want to keep the original subtotal as I need to get a few different subtotals for my project.
Solved by V. L. in 26 mins
Need help with excel assignment. Need to add column Subtotal. Calculate Subtotal.
Solved by Z. H. in 21 mins
When I link cells to another excel ss, and the second ss is subtotalled, the subtotal expands and I don't know how to keep the subtotal collapsed.
Solved by E. Q. in 21 mins
I need to create a shortcut to type in that will bring up the formula =subtotal(9,x:x+3), that also allows me to change the range. Define Name works but doesn't allow me to change the range of the things I am doing. For reference the reason I am needing this is work colleagues are getting confused with Subtotal(9, when they are so used to seeing sum( Thanks Leigh
Solved by V. H. in 24 mins
I have a range of data that I need to subtotal based on if it is yes or no. So person a total # of results (subtotal) but then within that subtotal how many yes and how many no. I know I can subtotal three times but was looking for one formula.
Solved by O. E. in 25 mins