+ Reply to Thread
Results 1 to 2 of 2

Subtotal function not showing while minimized

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    United States
    MS-Off Ver
    Excel 2008
    Posts
    25

    Subtotal function not showing while minimized

    I filtered the acc_code by top 10 revenue producers while the accounts are minimized by group. The subtotal of the groups reads 0 when minimized but once I click expand the revenue reads properly. Can anyone explain what is going on with this?

    Thanks TwardScreen Shot 2014-01-06 at 8.43.55 AM.jpg

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Subtotal function not showing while minimized

    It would help if you could upload a workbook rather than a screenshot. The subtotal function has different function numbers, such as 1, 2, 3, 4, 5 etc. which include hidden values and 101, 102, 103, 104 etc. which ignores hidden values. So if you minimize a group, I think it will make the values "hidden" and ignored if you are using a 101 type subtotal value.

+ 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. Replies: 3
    Last Post: 07-30-2014, 01:39 PM
  2. [SOLVED] showing the subtotal after clicking on the filter macro
    By extremis in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-30-2013, 04:11 PM
  3. Subtotal, Sumif Only Showing Visible
    By dprichard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2007, 08:21 AM
  4. showing userform with excel minimized
    By JNW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2005, 06:20 PM
  5. Showing Userform, while Excel starts as Minimized!
    By t4fast in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2005, 10:09 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