+ Reply to Thread
Results 1 to 3 of 3

Are Selective Subtotals Possible?

  1. #1
    Registered User
    Join Date
    11-24-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Are Selective Subtotals Possible?

    Is there a way to have subtotals only on selected columns?
    Below I have the following colums/rows. Can I remove the subtotal from the Rate column?
    I have used the "min" value for now so it doesn't add, but I would like to have it blank.

    Employee Sum of Hours Rate per hour Total
    101 32.00 $17.50 $560.00
    103 32.00 $17.50 $560.00
    105 40.00 $15.75 $630.00
    Grand Total 104.00 $15.75 $1,750.00

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Are Selective Subtotals Possible?

    If you look closer.. you can see..

    All SUBTOTAL' are formula.. like .. =SUBTOTAL(9,H8:H14)

    where you want .. to display MIN change this 9 to .. 5.

    refer.. help for other reference Number's like 2 - Count: 4 - Max

    Hope it will help..


    EDIT: re-reading the post

    at the time of apply subtotal.. you have option to choose.. (using check box) whether you want to apply any formula or not..
    Uncheck "RATE" section.. at the time of apply..
    Last edited by Debraj Roy; 11-24-2014 at 12:42 PM.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    11-24-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Are Selective Subtotals Possible?

    Thank you.

+ 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: 5
    Last Post: 12-11-2012, 05:04 AM
  2. create subtotals and copy subtotals to a new sheet with VBA
    By tonupgirl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2012, 01:36 AM
  3. [SOLVED] Subtotals: Nested subtotals below higher subtotal
    By RobN in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 04:10 PM
  4. Replies: 1
    Last Post: 06-20-2005, 07:05 PM
  5. [SOLVED] Problem with nested subtotals, placing secondary subtotals BELOW .
    By Dawn Cameron in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 06:05 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