Just use the subtotal
function to do the job. This function considers all your filters. =Subtotal(9, [your range])
.
The first parameter is the function code for Sum
function, you can find the list all function codes here.
BTW, the corresponding function in Microsoft Excel is Aggregate
function.