+ Reply to Thread
Results 1 to 10 of 10

subtotal - explain / brief

  1. #1
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    subtotal - explain / brief

    Ref. attachment AGRI

    Can someone explain about the subtotal formula applied in this file? I am unable to understand that.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by jilaba; 02-06-2017 at 03:21 AM. Reason: attachment uploaded
    Ask me how to hate XL.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: subtotal - explain / brief

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    Re: subtotal - explain / brief

    Quote Originally Posted by bebo021999 View Post
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Thanks. I will try.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: subtotal - explain / brief

    Did you try to attach a file? If so, nothing came through
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    Re: subtotal - explain / brief

    Quote Originally Posted by FDibbins View Post
    Did you try to attach a file? If so, nothing came through
    I tried, but seems it failed. Anyway i now uploaded it.

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: subtotal - explain / brief

    In "subtotal" function you can use "Average", "Count", "Counta", "Max", "Min", "Sum", "Stddev", & many more.
    Assume you would like to use sum. then use formula as per your range.
    Suppose your range is "B2:B23" then use formula in "B24" as : =SUBTOTAL(9,$B$2:$B$23)
    9 stand for "sum" and range is $B$2:$B$23
    Secondly if you filtered your data then also sum of filter range only.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  7. #7
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    Re: subtotal - explain / brief

    Quote Originally Posted by avk View Post
    In "subtotal" function you can use "Average", "Count", "Counta", "Max", "Min", "Sum", "Stddev", & many more.
    Assume you would like to use sum. then use formula as per your range.
    Suppose your range is "B2:B23" then use formula in "B24" as : =SUBTOTAL(9,$B$2:$B$23)
    9 stand for "sum" and range is $B$2:$B$23
    Secondly if you filtered your data then also sum of filter range only.
    Ok. Great thanks for that. i found a formula subtotal(109...) what is 109 meant for and where can i find abbreviations?

  8. #8
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    Re: subtotal - explain / brief

    Quote Originally Posted by jilaba View Post
    Thanks. I will try.
    sample attached.

  9. #9
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    Re: subtotal - explain / brief

    Quote Originally Posted by bebo021999 View Post
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    sample attached

  10. #10
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: subtotal - explain / brief

    Numbers 1-11 include manually hidden rows, whereas 101-111 exclude them.
    If any row mannually hide, then correct for subtotal(109) This calculated mannyally hide value, where subtotal(9) not calculated.
    Hope this will clear. Try with both in sample file & mannually hide any row.

+ 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. Im New...if subtotal exists then remove. if subtotal doesnt exist do nothing
    By ci89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2015, 04:53 PM
  2. Remove only 1 subtotal layer from Multi Nested Subtotal
    By goawohl in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 10-16-2014, 10:10 AM
  3. need subtotal to also include the matching data in subtotal line
    By baby_kay_2003 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-15-2014, 12:43 AM
  4. Replies: 1
    Last Post: 09-18-2013, 04:10 PM
  5. Replies: 8
    Last Post: 07-31-2012, 09:41 AM
  6. Subtotal - Delete zero Subtotal and prior rows that calculate to that zero Subtotal
    By Whatsherface in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 08:37 PM
  7. Replies: 3
    Last Post: 03-08-2006, 05:25 PM

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