Subtotals from multiple columns?
 

I subtotaled (sum) on 3 columns based on changes in a 4th column. There is a
5th column (repeating text info in all cells in the subtotaled groups) that I
want to display in the subtotaled (level 2) row. How do I get it to show?

Subtotals from multiple columns?
 

Hi
Go to Data/Subtotals again and select the subtotal requirement. Make sure
you uncheck 'Replace current subtotals' before you click OK.

Andy.

"grjk" wrote in message
...
I subtotaled (sum) on 3 columns based on changes in a 4th column. There is
a
5th column (repeating text info in all cells in the subtotaled groups)
that I
want to display in the subtotaled (level 2) row. How do I get it to show?