Subtotals from multiple columns?

G

Guest

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?
 
G

Guest

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

Andy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
Multiple formulas in subtotal 2
subtotal data from 2 columns into 3rd column 1
DELETING SUBTOTALS FROM A COLOMN 1
Subtotal/Consolidate/Pivot Table, Lookup ??? 2
Excel subtotals 1
Subtotals - show all columns? 2

Top