GET the SUM of Filtered Data in Excel

Learn how to SUM only filtered data in Excel. This tutorial will cover two quick and easy ways to ensure you get the SUM of only filtered data in Excel.

Timestamps:
00:00 Get the Sum of Filtered data in Excel
01:22 Option # 1 Replace SUM with SUBTOTAL
03:22 Option #2 Use a Total Row in a Table

Topic #56 and #67 in the ‘Steps to becoming Proficient in Excel’ workbook.

❤ VERSION FRIENDLY ❤
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelIntermediate #ExcelatWork

[ExcelatWork]

Need to find the correct SUM of filtered data in Excel? Let Sharyn help.

[joannemacgregor]

Awesome explanation. The shortcuts and extra tips were very helpful.

[cristinavissani]

fantastic exactly what I needed and clear concise information...Thank-you!🙂😉

[Emerson]

Really Neat - Thanks - and great accent to boot..

[nasheedvocalistyasir]

Excellent video. Very helpful. Thank you soooo much

[alejandrazazueta]

Hi, I'm using the subtotal function for average values however I need to apply multiple filters on my data, an it seems that is not working I get the same values for two different filters. How can I solve this? Thanks so much

[QadeerGhumman]

hi, after creating table for all given data range i did total row but its showing 0 in sum option. please guide me . Thank you

Hi, how do you lock a subtotal value as you update filters into another sheet or outside the table?

[odiaukpebor]

Please how do I fix the error ' you have entered too few arguments for this function '

[Chakieee]

Want to ask a question,
If i use SUBTOTAL function, then i got the result 3612.14 (inside the video)
Is there a method that I can keep this result when remove the filter?
As if I remove the filter, the SUBTOTAL result will turn back to 21261.38, which is the normal SUM.

[andrewarbogast]

what if you're using the countif formula?

[anime.manhwamania]

why i can't subtotal? still show auto sum to me