Thanks very much for your help!! Worked like a champ.

"Gary''s Student" wrote:

Yes...use the 101 code
--
Gary''s Student - gsnu200786


"Bear Black" wrote:

I know there is a subtotal function that will only add up visible cells when
using filters, but is there a formula that will average only visible cells
when using filters?