Can I Sum Data in Excel that is Filtered - 2574

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 answers all of 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 do a sum table excel filtered
how to do sum in excel with filtered data
how to do sum on excel with filtered column
how to exclude filtered cells from sum 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 only sum visible cells in excel
how to remove filtered cells from sum in excel
how to show sum of filtered cells in excel
how to sum a colum in excel with a filter
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 filtered column in excel
how to sum filtered columns excel
how to sum filtered tables in excel
how to sum filtered values 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 of filtered excel spreadsheet
how to sum only filtered data in excel
how to sum only visible cells in excel
how to sum only visible cells when filtering in excel
how to sum rows in excel excluding hidden rows
how to sum rows in excel when filtered
how to sum the filtered cells in 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 visable cells only in excel
how to sum visble cells only in excel
how to sum visibile cells only in excel
how to sum visible cells only in excel
how to sum visible cells only in excel?
how to sum with a filter in excel
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 cells in 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

Transcript of the video:

Getting the SUM of the visible cells after you apply a filter in Excel.
How to get a sum of data that's been filtered in Excel.
So no filters have been applied here yet.
And if we press the AutoSum button, we're going to get a sum function, which is going to total to 686.
The problem that we have is then if you then apply a filter, you see the 686 doesn't change.
Here's the solution.
Apply a filter to any column first, and then go to where you want the sum to be and press the AutoSum.
Because we're below a filter dataset, they change the function from sum to subtotal.
This nine says that we're going to sum.
The beautiful thing about subtotal with a nine says that it's going to only show us the rows that are visible from the filter.
So Charlie has 196, Betty has 170.
If we clear the filter, both the sum and the subtotal are going to be the same.
Now, there's one thing that you have to be aware of.
If you're hiding rows, not through a filter, but by simply hiding rows, the subtotal nine won't change, but they gave us a way to handle things that are hidden using the hide function.
Change the nine to 109, and then it ignores the rows that are manually hidden.
If you like these videos, please, down below, Like, Subscribe, and Ring the bell.
Feel free to post any questions or comments down in the comments below.