Issue is this. I have a table where the rows are individual accounts (first column) entitled "port", in the second column are names used to combine various individual accounts entitled "portc". The next columns (up to 100), all have figures that I want totaled by the various combined accounts, so its up to 100 totals by column B.
The problem is that I download the file in this format, but in summing my totals I need to invert the data and bring it into a spreadsheet where the combined accounts "portc" are column headings and my data items (the "up to" 100 additional data items) become the rows.
In the target spreadsheet the labels (both my "portc" label and the labels for the "up to 100" items are hardcoded, so I need to have flexibility in reading the column headings of my original spreadsheet to locate the right column to calculate my subtotals (by portc).
I've tried arrays, various forms of sumifs, and a number of things with cell reference functions, but no luck.
Any Ideas?
The problem is that I download the file in this format, but in summing my totals I need to invert the data and bring it into a spreadsheet where the combined accounts "portc" are column headings and my data items (the "up to" 100 additional data items) become the rows.
In the target spreadsheet the labels (both my "portc" label and the labels for the "up to 100" items are hardcoded, so I need to have flexibility in reading the column headings of my original spreadsheet to locate the right column to calculate my subtotals (by portc).
I've tried arrays, various forms of sumifs, and a number of things with cell reference functions, but no luck.
Any Ideas?
