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?
Your favorite shows are back!
Don’t miss your dramas, sitcoms and reality shows. Find out when and where they’re airing!