Forum Discussion
I'm doing a Simnet project.
Following directions with a table, I converted it to a range. This started at A5, which was below the headers. Then, use the Subtotal command to show a sum for the contract amounts for each city. H...
shbrin You should include the header row. Excel assumes that the first row in your data set contains headers. If you select "No", then your first row of data will be used as column headers and excluded from the sub-totals. So, click "Yes". Next time, let Excel do the work for you. Just select one cell anywhere inside your data range and then choose "Subtotal". Excel will recognise the top row as headers.
And don't worry. If you don't like the end result, press Ctrl-Z to undo your action.