I cannot for the life of me figure out how to format a column full of data so that I can subtotal the column. I'm working with data that we exported from Quickbooks. A client exported list of journal entries which needed so many rows that it took nearly two whole tabs to capture all the data.
I have been able to sort and sub-total the first tab without any problem. However, I cannot get the data on the second tab to foot using any functions. Note, the columns on both the tabs were custom formatted by Quickbooks upon exporting the data, but I'm only having problems with the second tab. I have tried formatting the cells within the columns to "accounting", "general", etc. and this doesn't help. Even the bar at the bottom of the excel window won't show a sub-total despite the changes to formatting.
Any help would be much appreciated.
I have been able to sort and sub-total the first tab without any problem. However, I cannot get the data on the second tab to foot using any functions. Note, the columns on both the tabs were custom formatted by Quickbooks upon exporting the data, but I'm only having problems with the second tab. I have tried formatting the cells within the columns to "accounting", "general", etc. and this doesn't help. Even the bar at the bottom of the excel window won't show a sub-total despite the changes to formatting.
Any help would be much appreciated.