sum in autofilter

If you're asking how to sum the values left visible after applying an autofilter, then use the SUBTOTAL() function instead of SUM() on you column D. SUBTOTAL() only adds visible data, hidden rows are ignored:

=SUBTOTAL(9, D1:D100)

hi

To add to JB's suggestion of using Subtotal I suggest inserting another row or two at the top of your page*, putting the subtotal in one of these rows above your data & then freezing the pane so that the subtotal & headers are always visible. This approach also prevents the need to move the subtotal if the number of data rows changes (or it gets hidden by the use of autofilter) & you can use a dynamic named range to define the size of the range used in the subtotal.


*I normally use 4-6 header rows to include general Title, data source, last update, subtotals & specific column headers then freezing the pane to keep them visible.

hth
Rob