How to use the Excel subtotal function, calculate subtotals in filters, and sum only visible values.
Here's how to use the Excel subtotal function!
When using Excel filters, you want to calculate only visible values, right?
↓Excel sample file for learning↓
File name: 6. Excel Subtotal Function
https://bit.ly/3z18XNT
Want to utilize various functions like average, sum, and count?
Instead of using sum and average functions to aggregate values that disappear,
try calculating only visible values with the Excel subtotal function!
Recommended videos to watch together
Short tutorial
Excel Practical] Calculating real-time subtotals by combining the SUBTOTAL function and filter function
BGM information
Track: Ikson - Shine [Official]
Music provided by Ikson®
Listen: Ikson – Shine