Thanks Subbu, Little correction in the last three steps:-
press up arrow and type " sum" <with space before "sum"> press Ctrl + Enter done Above should only be followed after you have done Subtotal for entire data set. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, subs <subbu1...@gmail.com> wrote: > > THANKS I APPRECIATE IT > > On Oct 1, 2:14 pm, Dilip Pandey <dilipan...@gmail.com> wrote: > > Hi Subbu, > > > > Two solutions:- > > 1) continue using subtotal but at the end do the trick as explained in > the > > attachment in sheet "option 1" > > > > 2) Do pivot table > > > > Thanks, > > Dilip Kumar Pandey > > Best Regards, > > -- > > DILIP KUMAR PANDEY > > MBA-HR,B COM(Hons.),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 110062 > > > > On 10/1/09, subs <subbu1...@gmail.com> wrote: > > > > > > > > > > > > > i am putting subtotals in exel 2007/2003 but i want to dispaly > > > additional columsn in the subtotals. how to do that > > > > > ex > > > > > st city price > > > oh a 20 > > > oh a 30 > > > oh a sum 50 > > > mi b 40 > > > mi b 80 > > > mi b sum 120 > > > > > i can display a in the subtotal row but not oh and a together > > > similarly b but not mi b and the list goes on > > > > > any help on how to get the data displayed exactly above > > > > > > > > Subtotal - by DILipandey.xls > > 12KViewDownload- Hide quoted text - > > > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
