Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Modifying the Calculations In Excel's Subtotal Feature

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
2.8K views 10 years ago
While Excel’s Subtotal feature can be a great way of summarizing data and creating drill-down reports, you are limited to using one of the tool’s eleven summarizing functions. Suppose you find a situation where you would like to use Subtotal, but the calculation you require – calculating a median, for example – is not one of the eleven available in Subtotal. In this tip, you will learn how to use a little trickery to “persuade” Subtotal to work just the way you want it to. ...more
...more
Comments are turned off. Learn more
Modifying the Calculations In Excel's Subtotal Feature
8Likes
2,873Views
2015Mar 22
While Excel’s Subtotal feature can be a great way of summarizing data and creating drill-down reports, you are limited to using one of the tool’s eleven summarizing functions. Suppose you find a situation where you would like to use Subtotal, but the calculation you require – calculating a median, for example – is not one of the eleven available in Subtotal. In this tip, you will learn how to use a little trickery to “persuade” Subtotal to work just the way you want it to.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers