Hi all... so I have a spreadsheet where I am have filters in my columns, and at the bottom, a sum and average formula. When I select one of the filters (insted of all I select one of the segments), I lose my sum at the bottom -- it actually hides it -- but I also need to see the sum and average of just that filter. How do I do that?