| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Justify text across multiple columns | Excel Discussion (Misc queries) | |||
| splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
| Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
| HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions | |||
Linear Mode
