Learn Excel How to Find Sum of Visible Rows
When we apply filter in excel and then we try to sum the filtered values, you would get the wrong total if you sum them with the sum formula.
The only way to sum visible rows in Excel is to use the Subtotal formula. It will only add up the Sum of Filtered Values and will ignore the hidden rows.
I have used the Subtotal function to show how we can add visible rows in excel.
Get the free Resue template： https://goo.gl/RBzSyP
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
Learn Basic Excel Skills For Beginners || Part 1
10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**
Learn Vlookup Formula For Beginners in Excel
5 Excel Questions Asked in Job Interviews
Create Speedometer Chart In Excel
Learn the Basic of Excel for Beginners || Part 2
Create Pareto Chart In Excel
How to Create Dashboard in Excel
Excel Interview Questions & Answers
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook – https://www.facebook.com/excelmadeasy/
Connect with us on Twitter – https://twitter.com/Excelmadeasy