I have an excel spreadsheet that tracks net and gross sales of a product. I am trying to autofilter the rows by date and then have the spreadsheet calculate a grand total for the range of dates I have chosen. To do this I choose "Subtotals" from the "Data" menu. My problem is that, in addition to giving me the grand total row, it also gives me an extra subtotal row for each and every date. How do I set it up so that it only gives me the grand total for the entire range, and not a subtotal for each date?
Help, my PC with Windows 10 won't shut down properly
Since upgrading to Windows 10 my computer won't shut down properly. I use the menu button shutdown and the screen goes blank, but the system does not fully shut down. The only way to get it to shut down is to hold the physical power button down till it shuts down. Any suggestions?