• Latest Updates

    How To Filter Data And Get The Sum Of Filtered Data Only of Excel Table

    If you are using excel to save your data then probably you may have a huge amount of data in your excel worksheet. So, due to huge amount of data there may some difficulties to check all of the data in once. And always we do not need all date in once. 

    So for some specific related data we use filter in Microsoft Excel to show only the required date in our excel worksheet. But while filtering the data it filters only data but our total sum and other calculations remain the same even it is hidden by filter.

    In this situation, we just want total sum of only those value that are now visible after filter data. So to get the total sum of only filtered data we have on single function in excel. i.e. subtotal(). 

    To know how to use this function, we have a tutorial video attached below which helps you to learn step by step procedure of using subtotal function of excel and get the sum of filtered data only of your excel worksheet.

    Please watch the video below and don't forget to subscribe our YouTube Channel. We have a lot of videos that really helps you to learn such skill of various software.

    How To Filter Data And Get The Sum Of Filtered Data Only of Excel Table

    No comments

    Post Top Ad

    Post Bottom Ad