Excel - Can I Sum Data in Excel that is Filtered - Episode 2574

Microsoft Excel Tutorial: Excel Total Data After Filtering.

Welcome to my Excel tutorial on how to get the SUM of visible cells after applying a filter. In this video, I will show you how to get a sum of data that has been filtered in Excel. This is a common issue that many Excel users face, but don't worry, I have a solution for you.

Before we dive into the solution, let's take a look at the problem. As you can see, no filters have been applied yet and the sum function gives us a total of 686. However, when we apply a filter, the sum remains the same. This can be frustrating when you want to get the sum of only the visible cells.

But fear not, here's the solution. First, apply a filter to any column. Then, go to where you want the sum to be and press the AutoSum button. This will change the function from sum to subtotal. The number 9 in the subtotal function indicates that we want to sum the visible cells only. This means that when we clear the filter, both the sum and the subtotal will be the same.

However, there is one thing to keep in mind. If you manually hide rows instead of using a filter, the subtotal 9 won't change. But don't worry, Excel has provided us with a solution for this as well. Simply change the 9 to 109 and it will ignore the manually hidden rows. And there you have it, a simple solution to getting the sum of visible cells after applying a filter.

If you found this tutorial helpful, please don't forget to Like, Subscribe, and Ring the bell for more Excel tips and tricks. And as always, feel free to leave any questions or comments down below. Thank you for watching and I'll see you in the next video!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

How can you sum data in Excel that has been filtered?
You have to apply the filter first and then AutoSum in Excel.
This video talks about the SUBTOTAL function in Excel.
There is a hack near the end in case someone is manually hiding rows in Excel.
In that case, change =SUBTOTAL(9, to =SUBTOTAL(109.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

This video answers these common search terms:
can i sum data in excel that is filtered
excel how to make sum change with filter
excel how to sum a filter
excel how to sum cells from a filter
excel how to sum filtered column
excel how to sum with filter
how do i sum filtered data in excel
how do you get a sum from excel when filtering
how do you sum a filtered column in excel
how do you sum only filtered items in excel
how do you sum only visible cells in excel
how to add sum of filtered numbers excel
how to apply sum formula to filtered cells in excel
how to autosum when filtered in excel
how to calculate sum with filter in excel
how to create sum of filtered data in excel
how to exclude hidden rows in sum excel
how to filter high to low for sumtotal in excel
how to filter sum in excel
how to get excel to sum only filtered cells
how to get sum of filtered column in excel
how to get the sum of filtered cells in excel
how to make excel take sum of filtered data
how to make sum calue in excel of filtered data
how to only show the sum of filtered data excel
how to sum a column in excel and filter
how to sum a column in excel when filtered
how to sum a filtered list in excel
how to sum a filtered table in excel
how to sum amounts in a filtered table excel
how to sum based on filter in excel
how to sum by filter in excel
how to sum excel column when filtered
how to sum filtered cells excel
how to sum filtered cells in excel
how to sum in excel filtered rows
how to sum in excel if the columns are filtered
how to sum in excel only filtered cells
how to sum in excel with a filter
how to sum in filter excel
how to sum up filtered cells in excel
how to sum values in excel when you filter
how to sum values with excel formula on filtered cells
how to sum with a filter on in excel
how to sum with hidden cells in excel
how to take a sum of visible sells on excel
how to take sum of filtered excel column
how to use sum function with filters in excel
in excel how to sum a filtered column

Table of Contents
(0:00) Problem Statement: Total Excel Data when Filtered
(0:10) AutoSum Won't Change After Filter Changed in Excel
(0:32) Solution: Apply Filter before AutoSum using SUBTOTAL function
(1:08) Manually Hiding Rows and the SUBTOTAL function 109
(1:31) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1233261/

Видео Excel - Can I Sum Data in Excel that is Filtered - Episode 2574 канала MrExcel.com