Get instant live expert help on I need help with insert 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
Go to the Earring worksheet and complete the following steps:
Sort the table by the Material field in ascending order.
Convert table to spreadsheet 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
Hi - how can i get Excel to auto sum the subtotals in my work sheet?
Solved by S. Q. in 28 mins
In Google Sheets. I have rows that have subtotals and then a grand total. I need to be able to insert rows, but Google Sheets isn't keeping the correct ranges in the subtotal or grandtotal rows.
Solved by Z. W. in 18 mins
I have to use the SUBTOTAL feature to count the number of records for each program and insert subtotals. This will tell me how many students are enrolled in each program.
VIEW using level 2 to display the count for each program
Solved by M. D. in 29 mins
Hi! I'm working in Google Sheets. I have a set of rows that interim subtotals and then a grand total. People need to be able to insert rows, but Google Sheets will NOT keep the subtotal/grand total calculations correct. I really need some help with this.
Solved by O. J. in 13 mins