Dear lenze and Beate Schmitz,
Sorry I did not post back sooner – I asked the question and then was delayed in getting back to check for an answer. Actually, all I was asking was if there was a way to get the Subtotal feature to work horizontally.
As for data setup, I have field names in F1:F3, data in cells G1:AL4, row one is sorted, and row 3 has the numbers to sum. So in row 4 for Subtotals I have used the formula:
=IF(G1<>H1,SUMPRODUCT($G$3:$AL$3,--($G$1:$AL$1=G1)),"")
And this works fine, I was just wondering if Subtotals feature would automate the process.
As for the CELL &"width" formula setup, that is quite a clever trick. I have not seen CELL and “width” used in such a way before. That is a good one for my Excel Toolbox!