I am trying to get a minimum value from a column using auto filter

I can't get the formula to only look in the filtered (visible) values,
like =SUBTOTAL(9,range)

It keeps giving me the lowest value from the total column.

Is there a solution?

Cheers,

Harold