Results 1 to 2 of 2

Thread: Subtotals

  1. #1

    Subtotals



    Register for a FREE account, and/
    or Log in to avoid these ads!

    If I have a list of values that are subtotaled by a certain category, is there an easy way for a user to quickly choose to include or exclude certain components from the total? Example:


    Sold 3
    Sold 4
    Subtotal Sold = 7


    Unsold 6
    Unsold 7
    Subtotal Unsold = 13


    Grand total = 20


    What if I want to set this up so that the user can choose to include or exclude the Sold subtotal in the grand total?

  2. #2
    If you set an autofilter on the data and put the totals above them using the =SUBTOTAL() function then when you filter the table the totals will only include the visible values.

    I've attached a primitive example. You could further simplify this by recording some simple macros for the key values you want and assigning them to buttons. When you filter any of the fields, the totals above update.

    Subtotal.xlsx

    Jesse

Posting Permissions

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