Search This Blog

Search Engine

Custom Search

20170221

What is the Formula in excel for filtered sum? Video Tutorial - You Tube Video

How to do Subtotal such that during filtering the sums keep on changing?

Video Duration - 70 seconds




If you filter a table month wise
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: