| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel subtotals
How do I add subtotals to columns instead of rows
|
|
#2
|
|||
|
|||
|
Jules wrote:
How do I add subtotals to columns instead of rows What exactly are you wanting to do? -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
|
#3
|
|||
|
|||
|
I believe you'll have to do it manually, by inserting the columns and adding
the formulas. On Thu, 10 Feb 2005 10:07:04 -0800, "Jules" wrote: How do I add subtotals to columns instead of rows |
|
#4
|
|||
|
|||
|
Instead of subtotals, you may find it easier, and more flexible, to use
a Pivot Table to summarize the data. There are instructions in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Jules wrote: How do I add subtotals to columns instead of rows -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel subtotals, add a sort option, and BOLD the function answers | New Users to Excel | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
| PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
