Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add more information in Sub Totals
I have a particularly large spreadsheet where I have lots of values
associated with property addresses and specific numerical references associated with the properties. I have used Sub Totals to calculate the total property values per location (building value, rental income, service charge etc) where the sub-total includes the property reference number alongside the sum of the values. What I want to do is not only show the property reference number but also the property description which is a text entry. From what I can see its only possible in Sub Total to use one column with text, for example, say in column A I have the Property Reference 12345J and in column B I have the location that corresponds to the property reference number 12345J and then separate columns under C showing the Building Value, Column D showing the Rental Value and Column E showing other income. With sub total I can say sub total property references and sum the total of columns C, D and E. The problem here is that when you print the listing it shows the sub totals against just the property reference and I'd like to also show the property location. The only way I've found of doing this is to copy and paste the data into the sub-total line which given the size of the spreadsheet will take ages. Is there a solution? -- David |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add more information in Sub Totals
Can you create an intermediate column which joins the two together, eg insert after B, and use a formula like =A1&"/"&B1 (which will give a result like "Ref/Address") Then use Column C as your subtotal group (and hide cols A and B). Regards Mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=564031 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How does one sort a block of inter-related information in Excel? | Excel Worksheet Functions | |||
Entering information from 1 worksheet to another, if criteria is m | Excel Discussion (Misc queries) | |||
Vlookups or Match to find multiple information | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) |