Sum Visible Values After AutoFilter Applied

  • Right now I have a column that has 1000's of numbers that has been autofiltered. When I filter to show only numbers higher than 10 I want the total sum of the line to then add only the numbers shown


    Numbers Filtered Numbers
    3 17
    17 49
    8 57
    4 Sum 123

    Sum 138

    Right now when I filter I see the same summed number before and after you filter the line.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!