Get instant live expert help on sort subtotals in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
on campaign subtotal .. include subtotals that calulate the total pesponses per type of social media (hint remember to sort the data and then add two sets of subtotals)
Solved by G. W. in 28 mins
Go to the Earring worksheet and complete the following steps: Sort the table by the Material field in ascending order. Convert the table to a normal range. Insert subtotals into the range A2:G25, with the subtotals appearing at each change in the Material column value. The subtotals should use the SUM function and include subtotals for the 2018, 2019, and 2020 fields. (Hint: Make sure to check the summary below data check box if it is not checked automatically.)
Solved by I. J. in 25 mins
On the JuneTotals worksheet, sort the data in the range A3:E16 in ascending order by Category. At each change in Category, use the Sum function to add subtotals to the data in the Amount column. Accept all other defaults. Collapse the outline to show the grand total and Category subtotals only.
Solved by F. J. in 30 mins
Hi - how can i get Excel to auto sum the subtotals in my work sheet?
Solved by S. Q. in 28 mins
I have a formula that isn't working all the time. I need to be able to sort this by rep to be able to add subtotals. can you help with that please?
Solved by M. J. in 22 mins