We can apply the SUBTOTAL function to get the maximum value or minimum value of visible cells only in Excel.

Select a blank cell you will place the maximum value of visible cells only into, type the formula =SUBTOTAL(104,C2:C19) into it, and press the Enter key. And then you will get the maximum value of visible cells only. See screenshot:

Notes:
(1) In above formula, C2:C19 is the list where you will get the maximum value of visible cells only.
(20 To get the minimum value of visible cells only, please apply this formula =SUBTOTAL(105,C2:C19).

Sum/Count/Average visible cells only in a specified range with ignoring hidden or filtered cells/rows/columns

>The normally SUM/Count/Average function will count all cells in the specified range on matter cells are hidden/filtered or not. While the Subtotal function can only sum/count/average with ignoring hidden rows. However, Kutools for Excel SUMVISIBLE/COUNTVISIBLE/AVERAGEVISIBLE functions will easily calculate the specified range with ignoring any hidden cells, rows, or columns.

This method will introduce the Conditional Formatting feature to get the maximum/minimum value of visible cells only easily in the filtered list.

1. Select the range you will get the max/min of visible cells only without the headers, and click Home > Conditional Formatting > New Rule. See screenshot:

2. In the opening New Formatting Rule dialog box, please:
(1) Click to highlight the Use a formula to determine which cells to format option in the Select a Rule Type box;
(2) Type the formula =$C2=AGGREGATE(4,7,$C$2:$C$22) (C2:C22 is the filtered column where you will get the maximum value of visible cells only, and C2 is the first cell of this filtered column ) into the Format values where this formula is true box;
Note: For getting the minimum value of visible cells only, please apply this formula =$C2=AGGREGATE(5,7,$C$2:$C$22).
(3) Click the Format button.

3. In the opening Format Cells dialog box, please specify a format as you need, and click the OK button.

In our case, we select a highlight color under the Fill tab. See screenshot:

4. Now it returns to the New Formatting Rule dialog box. Please click the OK button to apply this conditional formatting.

So far, when we filter the specified range, it will automatically highlight the row with maximum value (or minimum value). See screenshots:

Note: This method works well in Excel 2010 or higher versions.

2. Keep selecting the new range, and click Kutools > Select > Select Cells with Max & Min Value. See screenshot:

3. In the opening Select Cells With Max & Min Value dialog box, please:
(1) In the Go To section, please check the Minimum value option or Maximum value option as you need. In our case, we check the Maximum value option;
(2) In the Base section, please specify the scale you will get the max/min value. In our case, we check the Entire row option;
(3) In the Select section, please check the First cell only option or All cells option as you need. In our case, we check the All cells option.
(4) Click the Ok button.

4. Another Select Cells With Max & Min Value dialog box comes out and shows how many cells have been found and selected. Just click the OK button to close it. And then you will see the maximum value in each row has been found and selected. See screenshots:

Sum only filtered or visible cells in Excel

Count ignore hidden cells/rows/columns in Excel