Calculate Max and Min Value for only Visible Cells

[deaerator]

Hi,

I would like to calculate maximum and minimum value for a particular column when auto filter is applied and for only the visible cells.

Thanks in Advance

[martindwilson]

use subtotal () lo0k at help on function for options actual syntax is slightly different for versions of excel but in 97 subtotal(4,a1:b10) gives max of visible and subtotal(5,a1:b10) gives min
in 2007 its and in 2003
subtotal(104,a1:b10) gives max of visible and subtotal(105,a1:b10) gives min

[deaerator]

Thanks, It works.