How to do Subtotal such that during filtering the sums keep on changing?
Video Duration - 70 seconds
Video Link - https://youtu.be/sBiU-qyQj-w
If you filter a table month wise
The sum function at top or bottom still shows full year sum or full table sum
The sum function at top or bottom still shows full year sum or full table sum
We need to have the formula such that if we filter month wise then sum should come month wise
There is a formula in Excel for summing filtered rows only.
Everytime you filter various categories, the sum comes according to filter applied.
Also this formula can be kept at bottom of column or even at top of column
Formula is
SUBTOTAL(9,Range)
SUBTOTAL(9,E3:E11) where E3 to E11 consists of full data
No comments:
Post a Comment