 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Summing Subtotals
I have a worksheet with numerous subtotals and a grandtotal. The subtotals are separated by several individual entries for each subtotal. I have tried selecting each subtotal and the grand total cell, but when I hit enter it shows only the last subtotal. What am I doing wrong? Thanks for your help!  Signaturejim Jim, To sum a column of a sheet with subtotals included, you can use =SUM(B:B)/2 OR =SUM(B:B)/3 Since you have the grandtotal showing... But you really shouldn't need to do that. Describe better what it is that you are looking to do, and we can come up with a better way - Pivot Tables, perhaps.... HTH, Bernie MS Excel MVP >I have a worksheet with numerous subtotals and a grandtotal. The subtotals > are separated by several individual entries for each subtotal. I have tried > selecting each subtotal and the grand total cell, but when I hit enter it > shows only the last subtotal. What am I doing wrong? > Thanks for your help! Bernie, Thanks for the response. I have a spreadsheet showing sources of income. There are 6 subcatergories of income, each with a subtotal. In each subtotal I have no problem totaling the entries for each category, but when I try to select each subcategory and enter the result in a grandtotal it only enters the total for the last subcategory. I am using Excel 2007 in Home & Student. Hope this helps you. Thanks again! jim > Jim, > [quoted text clipped - 20 lines] > > shows only the last subtotal. What am I doing wrong? > > Thanks for your help! Jim, Grandtotals are added automatically.... in all versions, including 2007, if you are you using Data / Subtotals... If you are using the SUBTOTAL worksheet fucntion, you would need to use the SUM()/2 method. HTH, Bernie MS Excel MVP > Bernie, > Thanks for the response. I have a spreadsheet showing sources of income. [quoted text clipped - 30 lines] >> > shows only the last subtotal. What am I doing wrong? >> > Thanks for your help! Hi Bernie If you use =Subtotal(9,A3:A20), then =Subtotal(9,A4:A30) =Subtotal(9,A31:A50), =Subtotal(9,A51:A80) etc. then use =SUBTOTAL(9,A3:A80) will give the Grand Total, as the Subtotal function is intelligent enough to ignore any existing Subtotals within its range. SignatureRegards Roger Govier > Jim, > [quoted text clipped - 50 lines] >>> > shows only the last subtotal. What am I doing wrong? >>> > Thanks for your help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.