How can I get a formula to work on visible cells with autofilter?
 

I have a worksheet that has data for new items, repaired items, and some with
no values. I use autofilter to select only the rows for the repaired items,
and I want to do an average of these items only. when I put the funtion in,
it selects every row, rather than only the visible ones. Short of having to
click through each individual row for the average, is there an easy way to do
this? Thanks.

How can I get a formula to work on visible cells with autofilter?
 

Look in Help at SUBTOTAL

HTH
--
AP

"Jude Sweeney" <Jude a écrit dans le
message de news: ...
I have a worksheet that has data for new items, repaired items, and some
with
no values. I use autofilter to select only the rows for the repaired
items,
and I want to do an average of these items only. when I put the funtion
in,
it selects every row, rather than only the visible ones. Short of having
to
click through each individual row for the average, is there an easy way to
do
this? Thanks.

How can I get a formula to work on visible cells with autofilt
 

Perfect - exactly what I was looking for. Thanks!

Jude

"Ardus Petus" wrote:

Look in Help at SUBTOTAL

HTH
--
AP

"Jude Sweeney" <Jude a écrit dans le
message de news: ...
I have a worksheet that has data for new items, repaired items, and some
with
no values. I use autofilter to select only the rows for the repaired
items,
and I want to do an average of these items only. when I put the funtion
in,
it selects every row, rather than only the visible ones. Short of having
to
click through each individual row for the average, is there an easy way to
do
this? Thanks.