+ Reply to Thread
Results 1 to 6 of 6

totalling of subtotal values from the listed data

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question totalling of subtotal values from the listed data

    Hai to all, i want a formula which totals all subtotal values from the list of data

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: totalling of subtotal values from the listed data

    Hi, I want more information.
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    04-08-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: totalling of subtotal values from the listed data

    example
    product month total
    A April 250
    B April 500
    total 750
    A May 200
    B May 300
    Total 500

    ineed subtotal as =750+500=1250 (sum of subtotals)

    this i need any solution

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: totalling of subtotal values from the listed data

    are the subtotals obtained using the subtotal() function?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Registered User
    Join Date
    04-08-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: totalling of subtotal values from the listed data

    in the last cell of same column i need a formula showing link of subtotals

  6. #6
    Registered User
    Join Date
    04-08-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: totalling of subtotal values from the listed data

    its just example, actually subtotals obtained by sum function. i need the total value of each month to be added in last. and when i click on that cell it should show me from which totals grand total arrived

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to find any point within a 4R by 9C table of data between listed values
    By Bud Wilkinsonn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2013, 06:53 PM
  2. Need to find any point within a 4R by 9C table of data between listed values
    By Bud Wilkinsonn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2013, 04:22 PM
  3. Totalling Range Values
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2005, 09:05 PM
  4. Replies: 0
    Last Post: 08-25-2005, 02:17 AM
  5. [SOLVED] Totalling unique values
    By Stumped in forum Excel General
    Replies: 2
    Last Post: 07-27-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1