+ Reply to Thread
Results 1 to 5 of 5

excel 2007 grand total of all subtotal

  1. 05-11-2016, 05:39 AM #1
    cpramesh
    cpramesh is offline
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    excel 2007 grand total of all subtotal

    I want to put Grand total of all subtotal(sum formula) field only. pls help
    Last edited by cpramesh; 05-11-2016 at 06:56 AM.
    Reply With QuoteRegister To Reply
  2. 05-11-2016, 06:31 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,253

    Re: excel 2007 grand total of all subtotal

    =SUBTOTAL(9, Complete_range)

    as SUBTOTAL ignores intermediate subtotals.
    Reply With QuoteRegister To Reply
  3. 05-11-2016, 06:45 AM #3
    cpramesh
    cpramesh is offline
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: excel 2007 grand total of all subtotal

    No, it is not calculating
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-11-2016, 06:54 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,253

    Re: excel 2007 grand total of all subtotal

    Change your SUMs to SUBTOTAL

    =SUBTOTAL(9,D2:D6)

    =SUBTOTAL(9,D8:D12)
    Reply With QuoteRegister To Reply
  5. 05-11-2016, 06:56 AM #5
    cpramesh
    cpramesh is offline
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: excel 2007 grand total of all subtotal

    Thank you, it is working now
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to solve total, subtotal and grand total automatically...
    By blorban in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2015, 05:25 PM
  2. Subtotal method adds the grand total way further down on the sheet
    By ciocioiuc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2012, 02:17 PM
  3. Multiple Subtotaling (Subtotal the subtotals and grand total it all)
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 11-23-2010, 05:46 PM
  4. subtotal function grand total issue
    By tango in forum Excel General
    Replies: 1
    Last Post: 07-11-2009, 08:40 PM
  5. Subtotal/Grand Total Problem
    By johncassell in forum Excel General
    Replies: 2
    Last Post: 05-02-2008, 08:22 AM
  6. Subtotal \ Grand Total in VBA
    By mrdata in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2006, 05:03 PM
  7. [SOLVED] Subtotal of Subtotal displays Grand Total in wrong row
    By Thomas Born in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1