Before we experiment with the filtering, use any method you like to add a SUM() function to A9. You need to skip a row so Excel won’t interpret the function cell as data and filter it later. Filters ...