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

[Jude Sweeney]

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.

[Ardus Petus]

Look in Help at SUBTOTAL

HTH
--
AP

"Jude Sweeney" <Jude Sweeney@discussions.microsoft.com> a écrit dans le
message de news: 0FF417F6-2E4E-4A28-9ED6-70100DE3E35C@microsoft.com...
>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.

[Jude Sweeney]

Perfect - exactly what I was looking for. Thanks!

Jude

"Ardus Petus" wrote:

> Look in Help at SUBTOTAL
>
> HTH
> --
> AP
>
> "Jude Sweeney" <Jude Sweeney@discussions.microsoft.com> a écrit dans le
> message de news: 0FF417F6-2E4E-4A28-9ED6-70100DE3E35C@microsoft.com...
> >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.
>
>
>