How to sum filtered data in Excel

Sometimes, you want to be able to sum only the filtered data in Excel. This should work even when you change the filters to reflect sum of the new filtered data. This video shows the use of subtotal function in Excel to achieve this. #exceltips #sumfunction #subtotal #excelformulas #excelfunctions #excelforbeginners

Connect:

Course Alert:

Videos you may like:

Some Recommendations:
Note: At no extra cost to you, I may receive some commission if you purchase using the links above.

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance.

[laznluke]

I wish all "how to" videos were as concise and clear. You're the best! Thank you. Subscribed!

[BucketHatMan]

This is exactly what I needed. Thank you!

[gulsahkara]

Thank you for your help and keeping it short and clear <3

[jayminpatel]

but sometimes blank shows at sum and subtotal value when filter at first row. any solution?

[mustikadewi]

Bang, kalo mindah total ke sheet lain terus tapi totalnya jangan berubah lagi pas difiltwr gmna yaak 🙏🙏

[a.halimctg]

If there is sum negative value, then ?