View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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?