Subtotals

davidws

New member
Joined
Sep 8, 2011
Messages
8
Reaction score
0
Points
0
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?
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
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.

View attachment Subtotal.xlsx

Jesse
 
Top