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


    Example


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


    Sum 138


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


    Thanks

Participate now!

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