Max Values from Filtered Information - Excel

Hi, I have an Excel spreadsheet that has some data filtered out. When I try to find a 'MAX' value from one of the columns, the result includes values from the data that has been filtered out. How can I find a max value from the data included within the filter only?

KR, Glen