Get instant live expert help on subtotal function in excel

“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

I want to apply a formula to filtered cells only (i.e. what the subtotal function does, but with formulas that are not under the subtotal scope)
Solved by A. E. in 26 mins
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
in the shipping cell(cell H29), enter a formula that nests the vlookup function in an IF function to look up the shipping cost from the shipping cost table in the pricing and shipping worksheet based on the subtotal in cell H27. if the subtotal is 0, the shipping cost should display 0
Solved by G. D. in 12 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